View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default Rounding Decimals

Format as '0.00%' without the quotes.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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