Change numeric field to show whole numbers

P

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
 
P

Paul

Patti said:
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
Click to expand...

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

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
 
Top