If you want the actual value to be .2228 and the cell is actually
22.2849565... (and not a formula that results in that value), then you'll
have to create another column and do something like this: =round(a1/100,4).
Then convert those formulas to values and delete your original column.
************
Anne Troy
www.OfficeArticles.com

"Jim May" wrote in message
...
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