Percent Format

[Todd Huttenstine]

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

 

[Edwin Tam (MS MVP)]

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.99286733

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 yo

Todd Huttenstin

 

[Todd Huttenstine]

Thanx, it worked.