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.
I want to truncate fractions of a decimal number
