Excel 2003

  • Thread starter Thread starter lindle101
  • Start date Start date
L

lindle101

I am trying to open delimited data in Excel. When I do, my part numbers (in
this case, some with a dash) turn into dates. Is there a default I can turn
off or something? I need to keep them in the exact format so my vlookup that
I run recognizes them and can match them up. Ideas?
 
Get a Wizard to help you:

Open file file with:

Data > Import External Data > Import Data...

This will invoke the Wizard and you can instruct the Wizard to use something
other than date for the field in question.
 
I thought that would work. I actually tried it yesterday afternoon and kept
getting the dates. Numbers that do convert are ex. 1-1077 and 1-898, but
numbers that do not convert are 1-9006, 1-9007, 1-9018. They convert to
Jan-06, Jan-07, and Jan-18. I changed how that specific column should load
the data. Any other thoughts?
 
I created a file called C:\x.txt with the following contents:

1-9006
1-9007
1-9078
1-1077
1-1
1-898

I imported the file as posted. I told the Wizard to use the tab character
as the separator and defined the field to be Text (NOT General). The data
imported just fine..
 
Back
Top