Forum Discussion

Casg's avatar
Casg
Copper Contributor
Mar 05, 2024

Issue with automatic custom number formatting in Excel

 

Hello Excel Community,

I'm encountering an unusual behavior in Excel where it seems to automatically apply a custom number format under certain conditions, without my input. Specifically, when I enter numbers with a decimal point, the formatting is inconsistent. For example, entering '22.23' displays correctly, but when I input '95.53', Excel automatically changes it to '95.53.00'. This does not happen with all numbers, making it particularly perplexing.

 

I have not intentionally applied any custom formatting, and this issue seems to arise spontaneously. It's crucial for me to display the numbers exactly as entered, without additional zeros appended.

 

Could anyone guide me on how to reset Excel to its default number formatting or suggest a way to prevent this automatic custom formatting from occurring? Any insights into why this might be happening with specific numbers and not others would also be greatly appreciated.

 

Thank you in advance for your assistance!

Resources