Excel 2000

[Geoff]

When entering a digit and pressing return the numeric converts into thousands
i.e.
Enter 7 and press return gives the cell the value of 7000

 

[Bob Phillips]

Check Tools>Options>Edit. If Fixed decimal is checked, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Geoff]

Bob,

Many thanks for this.

Geoff

Check Tools>Options>Edit. If Fixed decimal is checked, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)