Excel automatically delete zeros

[omarfj70]

Hi,

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.

[#2]

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