Note: If you have limited experience using Excel functions try the Excel TRUNC Function Step by Step Tutorial which includes more detailed information about using this function.
This tutorial is intended for users familiar with using Excel's rounding functions.
Excel TRUNC Function Quick Tutorial
The TRUNC function, short for truncate function is used to remove the decimal part of a number to a set number of digits. In doing so, however, it does not round the remaining decimal places or whole numbers up or down.
The syntax for the TRUNC function is:
= TRUNC ( Number , Num_digits )
Number - the value to be truncated. This can also be a cell reference to the location of the number in the spreadsheet.
Num_digits - the number of decimal places to be left. If this argument is omitted, no decimal places will be left.
Example: Using Excel's TRUNC Function
For help with this example, see the image above.
- Enter the following data into cell D1: 34.567
- Click on cell E1 in the spreadsheet - this is where the function will be located.
- Click on the Formulas tab of the ribbon menu.
- Choose Math & Trig from the ribbon to open the function drop down list.
- Click on TRUNC in the list to bring up the function's dialog box.
- In the dialog box, click on the Number line.
- Click on cell D1 in the spreadsheet to enter that cell reference into the dialog box.
- In the dialog box, click on the Num_digit line.
- Type a 2 in order to leave 2 decimal places.
- Click OK.
- The answer 34.56 should appear in cell E1. Notice that the last digit was not rounded up.
- When you click on cell E1 the complete function = TRUNC ( D1 , 2 ) appears in the formula bar above the worksheet.