Excel question

[jyl]

I'm stumped on this one.

Normally, when I've formatted a cell as percentage, to enter 2.5% I can simply input "2.5" and Excel understands this is 2.5%.

Now, when I've formatted a cell as percentage, to enter 2.5% I have to input "0.025". If I input "2.5" Excel treats it as 250%.

What has changed?

[masraum]

right click and look at "format cell" when you click on "percentage", on the right, there's a box that says "decimal places". Somehow, you've changed that, I suspect.

[Don Plumley]

It's the order of formatting. If there is a number in the cell, and you press the % autoformat button, it keeps the decimal where it is and simply converts the display format. Hence 2.5 becomes 2.5%

If you format the cell for percentage first, you then need to enter the digits with the decimal in the proper location. So 0.025 properly displays 2.5%