In Microsoft Excel 2013, you can truncate numbers or formulas in your worksheet to return an integer rather than rounding the value based on decimal places. By entering the TRUNC function into the Formula Bar, Excel removes the fractional part of a value -- the numbers that appear in the decimal places after an integer. For example, truncating the number 5.9 results in the integer 5. The fractional part of the number is dropped from the value without rounding.
Open Excel and create a new blank workbook. Enter "8" into cell "A1" and then "3" into cell "B1."
Select cell "C1" and then type "=" (without quotation marks here and throughout the article) to signify the start of a formula. Select cell "A1," type "/", select cell "B1" and press "Enter." In cell C1, 2.666667, the quotient for the formula "=A1/B1," appears with six decimal places. Excel automatically rounds decimals to the sixth decimal place.
Select cell "C1" and click in the "Formula Bar" field, to the right of FX above your worksheet, placing your cursor on the right side of the equal sign. The Formula Bar lets you add functions and modify a formula for your current selection.
Type "TRUNC(" and then press "Enter." The formula truncates the decimal places, returning the number 2, which is the integer part of 2.666667. If you reference this cell in other formulas in your worksheet, the value is calculated as an integer without the original fractional part.
Tips & Warnings
- To decrease the decimal places for a number, select the cell containing the number you want to adjust and then click the "Decrease Decimal" command, resembling zero decimals with a left arrow, in the Number group of the Home tab. Increasing the decimal places for a truncated integer adds zero decimals after the integer.
- If you want to truncate a number that is not part of another formula, enter the formula into a new cell. For example, select an empty cell, type "=TRUNC(5.8" and then press "Enter." The truncated number appears as the integer "5." You can apply the TRUNC function to most formulas in Excel.
- Substitute the TRUNC function for the INT function to round the number down to the nearest integer based on the value of the decimal places. For example, the formula "=INT(-6.4)" returns -7 because it is the lower integer number.