Reformatting numbers
 

I received a worksheet with numbers derived from formulas in the cells. I
converted the formulas to values so I was left with only the results of the
formula. However, the numbers have about eight digits after the decimal
point. How do you eliminate all decimal places after the first two? I'm
using an old 1997 Excel version.

Reformatting numbers
 

You could have used the ROUND function before you converted it but since it
is already converted one way would be to do formatcellsnumbernumber and
set it to 2 decimals, then toolsoptionscalculation and check precision as
displayed, click OK and then remove the checkmark after this has been done
so you don't always use this. Note that it will round the 2nd decimal and
not truncate it

--

Regards,

Peo Sjoblom

"skacleve" wrote in message
...
I received a worksheet with numbers derived from formulas in the cells. I
converted the formulas to values so I was left with only the results of
the
formula. However, the numbers have about eight digits after the decimal
point. How do you eliminate all decimal places after the first two? I'm
using an old 1997 Excel version.