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
Highlighted

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

Related Conversations