software

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.

You could have used the ROUND function before you converted it but since it
is already converted one way would be to do formatgt;cellsgt;numbergt;number and
set it to 2 decimals, then toolsgt;optionsgt;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

--

Regards,

Peo Sjoblom

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