Excel automatically delete zeros

Occasional Visitor



I don´t know what happened, but when I type 400 on any cell, Excel put only 4. If I need the 400 to be on the cell, I need to type 40000, and then the cell valué is 400.00.

Can some one help me to reverse this behavior?. I am using Excel on MAC.

1 Reply

I'm not sure about Mac, but on Windows that setting


is to be deselected to avoid such effect.


Most probably you have similar setting on Mac as well