View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Disable formatting on csv open?

"Heather1270"
wrote in message
...

Hi!

When opening a csv file in 2003, Excel "formats" the data - it coverts
one field that is text but looks suspiciously like a date to a date
field. Is there a way to disable this or set Excel to open the file
with all fields formatted for text?


The easiest way is to rename the file to .txt instead of .csv, then the text
import wizard allows you to select the format for each column.
--
David Biddulph