Forum Discussion
Problem With Percentage
Hi i am new to excel, and when i try to put for example 2.5% on my cell then it shows 250.00%
I have tried cell format under percentage, your help will mean a lot to me.
In addition to Haytham's advice, also note that the percentage format works like this when using whole numbers:
1 = 100%
0.5 = 50%
1.6 = 160%
10 = 1000%
And so on and so forth. Can be applied to formulas too.
Cheers
Damien
1 = 100%
0.5 = 50%
1.6 = 160%
10 = 1000%
And so on and so forth. Can be applied to formulas too.
Cheers
Damien