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 ...
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)
Something interesting is happening. So I did the same thing. I went to a new cell with it in "General" format, and typed 0.0929. Then I switched it to Percentage, and it immediately put it at 9.29%. This is fabulous. However if I delete the 9.29%, and type in 0.0929 again, it defaults back to the 0.09% instead of the 9.29%.