import csv without automatic date conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import a csv file with fields in the format "n/n" where n is any
integer, Excel automatically converts that field into a date, i.e. "Jan-01."
How do I stop Excel from doing the automatic conversion? I want to keep the
data in its original format. I'm using Excel 2000 9.0.3821. Thanks.
 
You need to rename the file to txt then use the text import wizard and import
the n/n/ as text in step 3


Regards,

Peo Sjoblom
 
Back
Top