How to Truncate Excel 2007 Data

In this video tutorial we will show you how to truncate excel data.



In order to use truncate function in excel, open your excel document. To truncate your data, just type “trunc(a1,2)”, where “a1” is a cell number and “2” is a quantity of numbers after dot. If you want to edit other cells in a column, then left-click in the lower right corner of the cell with the formula, hold and drag it down.
Drag to select

Now you know how to truncate excel data.

Related posts:

  1. How to Make Excel 2007 Formulas Roundup
  2. How to Change Excel 2007 Cell Color Based on Value
  3. How to Write Excel 2007 IF Function
  4. How to Print an Excel 2007 File with Header Row on Every Page
Posted on February 1, 2013 by . This entry was posted in Office and tagged , . Bookmark the permalink.