When I attempt to calculate a percentage in Numbers... The calculation result is incorrect.
Here's a simple example...
100 x .8 = 80%
Numbers is giving me the result of 8000% Screen shot included.
I'm loosing my mind trying to figure out how to fix this.
Macbook Pro 2.66 GHz i7, Mac OS X (10.6.3), 8GB RAM, 512GB SSD HD
.8 is 80% (Try putting .8 into a cell and format it as a %)
100 times 80% is 8000%
Excel gives the same result if you multiply 100 times .8 and format the result as %.
.8 is 80% (Try putting .8 into a cell and format it as a %)
100 times 80% is 8000%
Excel gives the same result if you multiply 100 times .8 and format the result as %.
Thanks so much... I didn't realize that Numbers already auto calculates the percentage.... This was driving me mad.
Percentages are calculating incorrectly
