Tools>options>edit>Fixed decimal places = 2

[Michael]

The override mentioned in the last sentence below does not
work in Excel 2003. Can anyone help with this?

Fixed decimal:

Enter the number of decimal places in the Places box to
indicate where Microsoft Excel will automatically put the
decimal point in the numbers you enter as constants on a
worksheet. A positive number moves the decimal point to
the left; a negative number moves the decimal point to the
right. If the Places box is left blank or set at 0 (zero),
you need to enter the decimal point manually. To override
this option, type a decimal point as you enter the number.

 

[Frank Kabel]

Hi
Excel 2003 changed the behaviour of this option. So nothing you can do