| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Auto-Correction
When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not
want this to happen, how do I turn off this auto-correction so it never happens again? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Auto-Correction
You can't change the input parser's behavior, but you can bypass it by
either (a) prefixing the entry with an apostrophie ('), or (b) preformatting the cell as Text so that it isn't parsed. In article , Mozman wrote: When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not want this to happen, how do I turn off this auto-correction so it never happens again? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Auto-Correction
Type an apostrophe and then the score('1-5) or format the cells to text
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Mozman" wrote: When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not want this to happen, how do I turn off this auto-correction so it never happens again? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Auto-Correction
one way...
press a space bar then type 1-5 "Mozman" wrote: When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not want this to happen, how do I turn off this auto-correction so it never happens again? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| most recent date (correction) | Excel Discussion (Misc queries) | |||
| Auto Correction | Excel Discussion (Misc queries) | |||
| Auto Correction | Excel Discussion (Misc queries) | |||
| Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
| assign auto number and auto date | Excel Discussion (Misc queries) | |||
Linear Mode
