Thread: Percent
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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