Percent Format

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

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
 
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
 
Back
Top