Thanx, it worked.


-----Original Message-----
You can set the cell's number format to :

0.00"%"


----- Todd Huttenstine wrote: -----

In a worksheet in various cells I have values. Some
values need to be converted to percents, but when I
right
click a cell on the spreadsheet and use the format
function, the percent format is all messed up.
For instance, lets use the following number that is
located in cell A1...
4.992867332

When I change the format to percent and try to round
2
places (like I want to round) it produces the value
499.28
percent. This is wrong. I need it to say 4.99
percent.

Is there some code that I can use to specifiy for
any
value in cell A1, it be converted to XX.XX% format?


Thank you

Todd Huttenstine

.