View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default Percentage displaying wrong

In article , ?B?VEFWMDcy?= wrote:
We have a formula that is calculating an average of scores and when the
answer appears, it appears like 9850.0% instead of 98.5%. How can we fix
this?


Sounds like you have the '%' format selected. If you use that, you need to
get 0.85 in the cell to show 85 % (IIRC :) ).
You are doing the *100 in the calc, yes ? Either don't and leave the %
format on, or leave that calc alome and turn the % format off.

I know, really confusing. I tell people not to use the % format. The last
thing I want is random multiplication in my spreadsheets. :)

HTH