Tools-Options-Calculation-Precision as Displayed

will round all numbers to the format you display them. Be carefull you will
permanently lose any accuracy. Also, after you finish you might want to turn
it off. It does funny things with formulas. For instance
A1=1+0.123
A2=A1

A2 will equal 1.12000000000000 if A1 is formatted to two decimal places and
you have "Precision as Displayed" checked.

"Precision as Displayed" is perfect for rounding massive amounts of imported
data, but I have not found any other viable use for it. Hope this helps.

"Jim May" wrote:

I've got 2 or 3 thousand figures
that display as (sample) 22.3% with actually
22.2849565849694 in the cell.
I need to "do what" ? in order to convert
them to display 22.28% with actually
.2228 in the cell?

Tks in advance