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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies