Excel spreadsheet applications and tips

Home

 

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.



Visit
http://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