View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
artech artech is offline
external usenet poster
 
Posts: 1
Default import /paste -stop automatic conversion of text 05-12345 to date

When importing or pasting a text file with a non-date field that starts with
a 2 digit number and hyphen (05-99999, 06-99999) excel automatically converts
the entries to a date. I have tried turning off error checking but that did
not help.

If I pre-format the cells as text before the paste, it does not convert to
date. But when downloading I do not have this option. What feature do I need
to turn off?

Thank you