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.
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