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 to display as Percentage, but it dispslays 0.9%. I cannot do, for example, =M4*100 and then make cell M3 display it as a percentage with 0.00\% because M3 still thinks it is 929.00%. The reason why is because I'm using the value in cell M3 to add it into the taxes in another cell. I wish I could attach Excel files like the old days so people could pick it apart better. I'm going a bit crazy because I have even tried using ChatGPT to help and it keeps just telling me that by editing the formatting for M3 to be decimal with 2 decimal places, it should be converting 0.0929 to 9.29% but it doesn't. And I made sure that I have turned off "Set precision as displayed". HELP PLEASE!
7 Replies
In addition, it is assumed initially the cell is in General format. If you manipulate with the cell which is already in Percentage format result could be bit different. Let assume you have blank cell with Percentage format applied
and when we type 0.0929 here, result is
That's odd because I just copied your cell at X6 down to X7 and typed 0.0925 and got 9.25%
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%.
https://communitas123-my.sharepoint.com/:x:/g/personal/kdfox_communitas_org/IQDYuvivVOuaTqml3u0MaipKATjvHu4inOpS4tjf08pd0Qg?e=FEHd7c
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.
