Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Percent Format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Percent Format
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Percent Format
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox on a userform - format to currency & percent | Excel Discussion (Misc queries) | |||
Custom Format - Percent | Excel Discussion (Misc queries) | |||
Conditional format if a cell has a formula or if a percent or numb | Excel Discussion (Misc queries) | |||
Custom percent format needed | Excel Worksheet Functions | |||
How do I format a negative percent? | Excel Discussion (Misc queries) |