View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

If plain numbers are being displayed as dates, change the format to
General (Cells/Format/Number).

XL's parser will, independently of autocorrect, always interpret a
string like x/y or x-y as a date if it can. To enter such strings
without being parsed, format the cell as Text before entering the
string, or precede the string with an apostrophe, e.g.:

'11-2

In article ,
"Becca C" <Becca wrote:

I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?