Reformatting numbers

S

skacleve

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.
 
P

Peo Sjoblom

You could have used the ROUND function before you converted it but since it
is already converted one way would be to do format>cells>number>number and
set it to 2 decimals, then tools>options>calculation 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
 
Top