Stop Automatic Date Conversion

  • Thread starter Thread starter Jerry Baker
  • Start date Start date
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.
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to Date Conversion 5
CSV Dates Not Sorting 5
Stopping excel from converting numbers into dates on import 10
CSV and Custom Fields 6
Stop Converting to Date 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13
Date problem when opening a csv without dates 8

Back
Top