import csv without automatic date conversion
 

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

"shinta" wrote:

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.