How To Truncate Decimals In Excel
Using The Function “TRUNC“
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Excel is great about giving you exactly the numbers you want.
You can tell it how many decimal places you’re looking for, how it should round, and how many digits to display.
But sometimes you just want a shorter number. Excel can make that difficult.
With the TRUNC function, you can get shorter versions of numbers without getting rid of the original version. And that makes data easier to work with.
Let’s check it out.