How to remove decimals from numbers (TRUNCATE function)
Removing decimals from numbers is extremely easy when you use the TRUNCATE function.
Give a number to the function – it will chop it down and return a truncated number as a result. Easy, no? 😀
Let’s now look at its syntax to understand the function better.
The number argument specifies the number or cell reference that is to be truncated.
The digits argument specifies the number of decimal points you want to remove. This is an optional argument.
Note that the TRUNC function doesn’t round or change the format of the number. However, the INT function rounds a number and eliminates the decimal places in one go. You can give it a shot.
Let’s now see how the TRUNC function works in Excel.
Enter a number 5.946 in the TRUNC function in cell A2 as:
The TRUNC function returns a result 5.
That’s because when you don’t specify the second argument, the TRUNC function eliminates all the digits after the decimal point. And returns the integer part of a number 🤔
You can do the same using a cell reference.
- Select cell B1.
- Enter A2 in place of the first argument in the TRUNC function.
And tada! You guessed it right – both arguments return the same results.
You’re getting better at it already 😉
Now let’s use the TRUNC function with the second argument.
- Select cell B2.
- Enter the formula as:
Notice that Excel returned the answer with two decimal places in the result.
That’s because we entered 2 in the formula for two decimal places. And Excel returns 5.79, which is exactly what we asked for.
It’s that easy to use the TRUNC function in Excel 🥇
We have added some more values for you to practice in the sample workbook.