View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jesoldano@gmail.com is offline
external usenet poster
 
Posts: 31
Default trouble formatting percentages

Hello, I am having a tough time getting a document to display
percentages correctly. For example, I want a percentage to show up as
"20%" but for whatever reason, when I type in "20" into the cell it
automatically kicks back 2000%. I have cleared formats several times,
and have my format set on "Percentage, 0 decimal places." Any idea
what I am doing wrong?