=ROUND(A1,4) works perfectly;
Thanks,
Jim

"Duke Carey" wrote:

Since you want .2228 in the cell, you are looking to round to the 4th decimal
place. You'd use

=ROUND(.222849565849694,4)

or

=ROUND(A1,4)

You may also want to look at the Help file for info on the TRUNC() ,
ROUNDUP() and ROUNDDOWN() functions

"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