View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default prevent converting numbers with hyphens to dates

I have a csv file that includes a column that contains text in the format
1-2-14. These are not dates, they are text and must remain in that format. I
have tried importing, pasting, everything I can think of (including the
obvious cell formatting) with no luck. They are converted into dates and I
can't get them back into the right format. Can anyone help?

Thanks in advance
Mike