View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?