**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.

**Related Tutorials**