Home

Excel automatically delete zeros

Highlighted
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies