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