Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |