Excel 2000
 

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

Excel 2000
 

Check ToolsOptionsEdit. If Fixed decimal is checked, uncheck it.

--

HTH

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


"Geoff" wrote in message
...
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

Excel 2000
 

Bob,

Many thanks for this.

Geoff

"Bob Phillips" wrote:

Check ToolsOptionsEdit. If Fixed decimal is checked, uncheck it.

--

HTH

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


"Geoff" wrote in message
...
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