Number Format

C

Clute

All of a sudden my worksheet will not input dcecimals automatically...i.e
1000 and it enters 10....with or without formatting decimal places. I need
Click to expand...
1000.00. Anyone know how to stop this. No matter whether I format the column
or just the cell it compresses the number.
 
P

Pete_UK

Click on Tools | Options | Edit tab and uncheck the option Fixed
decimal, about half-way down.

Hope this helps.

Pete
 
Top