Change numeric field to show whole numbers

[Patti]

Column A calculates number of months and calculates the
result out to many decimal points. I've changed it to
show only whole numbers but it still sorts by the original
number. How can I physically change the decimal point
number to a whole number? Example: 2.003 to 2, not only
see 2 but when you put your cursor on the cell it shows 2
NOT 2.003

 

[Paul]

Column A calculates number of months and calculates the
result out to many decimal points. I've changed it to
show only whole numbers but it still sorts by the original
number. How can I physically change the decimal point
number to a whole number? Example: 2.003 to 2, not only
see 2 but when you put your cursor on the cell it shows 2
NOT 2.003

Round the result of calculating the number of months to an integer:
=ROUND(YourFormula,0)

 

[Adiv]

It is better to use the INT worksheet function instead of ROUND becaus
ROUND can change a value like 5.6090 into 6 instead of 5. That wil
affect the sorted list, so you need to take into account the effects o
rounding