Forum Discussion
Percentage HELP!
I'm using Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20244) 64-bit In Cell M3, I want to be able to type in 0.0929 and have it convert to 9.29%. I've tried formatting it ...
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.