Excel spreadsheet applications and tips



How to truncate fractions and convert decimals to whole numbers (value changed)?

Fractions can be simply deleted with change in values by using the function =ROUNDDOWN(A1,0) where A1 denotes the cell reference number. Please refer to the following excel spreadsheet for example.

https://www.ozgrid.com/Excel/excel-rounding.htm for more rounding options.

Search engine keywords for this question
I want to delete fractions of a decimal number

I want to truncate fractions of a decimal number