Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
11 becomes 12 after hit return
If I type 11 in one cell, 11 will show up in the cell. However, after I hit
the return, 11 becomes 12 autimatically. All the number keys are working. If I type 1 or 111, all are fine except 11. This is also true in Word. Is this related to office or is this to the computer. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
11 becomes 12 after hit return
Try this
Tools|Autocorrect option and type 11 in the Replace box Delete the enrtry for replace 11 with 12 Mike "XD-San Jose" wrote: If I type 11 in one cell, 11 will show up in the cell. However, after I hit the return, 11 becomes 12 autimatically. All the number keys are working. If I type 1 or 111, all are fine except 11. This is also true in Word. Is this related to office or is this to the computer. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
11 becomes 12 after hit return
Probably a local AutoCorrect setting (set in that PC's Excel by a previous
user). Check the entry (11) under Tools AutoCorrect options (Type: 11 in the "Replace:" box). Then just select the entry, click Delete button. Joy? Click YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "XD-San Jose" wrote: If I type 11 in one cell, 11 will show up in the cell. However, after I hit the return, 11 becomes 12 autimatically. All the number keys are working. If I type 1 or 111, all are fine except 11. This is also true in Word. Is this related to office or is this to the computer. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
11 becomes 12 after hit return
Maybe you should check ToolsAutomatic corrections
If you find 11 in the dictionary, delete it! Regards, Stefi €˛XD-San Jose€¯ ezt Ć*rta: If I type 11 in one cell, 11 will show up in the cell. However, after I hit the return, 11 becomes 12 autimatically. All the number keys are working. If I type 1 or 111, all are fine except 11. This is also true in Word. Is this related to office or is this to the computer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
How to return 1 with #VALUE!? | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
1.23 return to 0.23 | Excel Discussion (Misc queries) |