Number formatting - what's going on?

Y

yhtak

My cell format is "general" with no decimal places and comma separator
ticked... if I enter a number e.g. 54389, the last two digits are dropped and
the number rounds up. If I type the comma e.g. 54,389 it displays correctly.
On Friday I didn't have to type in the comma, now I do. Can anyone explain
what I need to do to get it to go back to the original format?
 
D

David Biddulph

yhtak said:
My cell format is "general" with no decimal places and comma separator
ticked... if I enter a number e.g. 54389, the last two digits are dropped and
the number rounds up. If I type the comma e.g. 54,389 it displays correctly.
On Friday I didn't have to type in the comma, now I do. Can anyone explain
what I need to do to get it to go back to the original format?
Click to expand...

Tools/ Options/ Edit
Uncheck "Fixed Decimal Places"
 
Top