Remove All Decimals in Excel

Remove All Decimals in Excel

The process to remove all decimals in Excel worksheets is easy and only requires a formula to accomplish. The process of changing decimals numbers to truncated numbers is helpful when you are tired of doing math with large numbers.

Download our example spreadsheet to follow along and learn how to accomplish this feat.

In the example worksheet, there are five decimal numbers you can practice truncating. For this example, select cell C8 and enter the following formula:

=trunc(b8)

C8 should now have “145” entered.

If you want to truncate the rest of the numbers, simply drag cell C8 down to C12 and the formula will adjust and change each decimal number into a whole number.

There is also another use for the truncate formula that you can use if you want the decimal to remain, but to shorten the length of it.

Select cell B8 and enter this formula:

=trunc(b8,1)

B8 will now read “145.3”. Chance the “1” in the formula to allow more decimals if you want.

Learn more about Excel wizardry with our Excel tutorials.

 

Related Templates:

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.