| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percent
How do I format a cell to show the percent in stead of decimal? I have C1/C2
in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percent
To reformat a cell from decimal to percent, click on the cell, then click on
the Percent sign up in the Standard Toolbar. But, .31 relates to 31%, not 3%.....if you want 3% then use this formula =(C1/C2)/10 Vaya con Dios, Chuck, CABGx3 "Octet32" wrote: How do I format a cell to show the percent in stead of decimal? I have C1/C2 in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percent
Thanks
"CLR" wrote: To reformat a cell from decimal to percent, click on the cell, then click on the Percent sign up in the Standard Toolbar. But, .31 relates to 31%, not 3%.....if you want 3% then use this formula =(C1/C2)/10 Vaya con Dios, Chuck, CABGx3 "Octet32" wrote: How do I format a cell to show the percent in stead of decimal? I have C1/C2 in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percent
You're welcome......thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Octet32" wrote: Thanks "CLR" wrote: To reformat a cell from decimal to percent, click on the cell, then click on the Percent sign up in the Standard Toolbar. But, .31 relates to 31%, not 3%.....if you want 3% then use this formula =(C1/C2)/10 Vaya con Dios, Chuck, CABGx3 "Octet32" wrote: How do I format a cell to show the percent in stead of decimal? I have C1/C2 in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percent
Format Cells... Number Percentage
But be aware the .31 will display as 31% rather than 3% Have a pleasant day!! -- Gary's Student "Octet32" wrote: How do I format a cell to show the percent in stead of decimal? I have C1/C2 in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percent rank | Excel Worksheet Functions | |||
| Track progress to lookup percent complete on another worksheet. | Excel Worksheet Functions | |||
| two columns percent in third | New Users to Excel | |||
| Percent Change | Excel Discussion (Misc queries) | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Hybrid Mode
