Forum Discussion
Percentage HELP!
it works for me if you
a) click the % button to format as 'Percentage'
b) then click the increase decimal points 2x (the button below the $ on this image)
I don't know what is going on then. When I type in 0.0929 into the cell, and then use that button, it changes from 0.0929 to 0.09290000 and just keeps adding zeros after the last "9" in the cell. When I use the Decrease Decimal button instead it eventually just shows 0.
ok in the web version the buttons are 'reversed':
step 1: highlight cells to be formatted
step 2: click on the % button (shown in image above)
step 3: click on the increase decimal places button (the one on the right in the image above with the arrow pointing right)
step 4: enter your value (e.g. 0.0929) and is will show as 9.29%
I have formatted cells M4:M20 this way for you to try out.