Stop Automatic Date Conversion

J

Jerry Baker

I have a CSV file that contains a field listing a school's grade span
(e.g., 9 - 12). When I open this CSV file in Excel it converts these to
dates. How do I stop this behavior? Changing the format of the cells is
no help as the data is lost on conversion.

Thanks.
 
D

Dave Peterson

Change the filename to *.txt

Then when you open it, you'll see excel's text import wizard.

You'll be able to choose each field's format (text for those 9-12 columns).
 
Top