View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Pre-format the cells as text or pre-fix entry with a single apostrophe. (It
will not show but will stop the conversion)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Buckwildbill" wrote in message
...
I would like to type in 1-3 but it keeps getting turned into 3-Jan. I have
turned off every option in excel that I can find but it still keeps
happening.