Thread: Opening CSV, How to Tell Excel String is not a Date?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim G
 
Posts: n/a
Default Opening CSV, How to Tell Excel String is not a Date?
In a CSV file I have values like "3-1". Excel interprets this as a date:
3/1/05. What encoding can I use in my CSV files to force Excel to read it as
a literal string? I have already tried double quotes around the string.

I am using Excel 2003.
Reply With QuoteReply With Quote