Percentage HELP!

Question

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!

m_tarler · Answer

it works for me if you&nbsp;a) click the % button to format as 'Percentage'b) then click the increase decimal points 2x (the button below the $ on this image)&nbsp;

kevincommunitas · Answer

I don't know what is going on then.&nbsp; 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.&nbsp; When I use the Decrease Decimal button instead it eventually just shows 0.