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
|