Home

Excel automatically delete zeros

omarfj70
Occasional Visitor

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.

1 Reply

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

image.png

is to be deselected to avoid such effect.

 

Most probably you have similar setting on Mac as well