If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2003
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? |
#2
|
|||
|
|||
Excel 2003
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. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? |
#3
|
|||
|
|||
Excel 2003
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? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? |
#4
|
|||
|
|||
Excel 2003
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.. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? |
#5
|
|||
|
|||
Excel 2003
I finally got it. I appreciate your help. Thanks!
"Gary''s Student" wrote: 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.. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200798 "lindle101" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|