Part number surrounded by quotation text qualifier imports as a number not text

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to import a comma delimited text file which contains among
other information, a numeric part number (ie 00123). I surround the
part number with quotes and import indicating use quotes a text
qualifier. No mater what I do, Excel still refuses to import this data
as text, it always converts it to a number (123). This is an issue
because this Excel file will be going into another program which will
be using that field in table relationships. Can't fix it after the
fact because all of the part numbers are different (00123, 0001.,
1234A, etc...) I have turned off all error checking under Options,
Error Checking. Has anyone experienced this before, or know of a
remedy. Checked out Microsoft for info, to no avail.
 
Try this:

After pre-formatting your XL columns to text, delete the .csv extension
before importing and/or opening this new file.
XL will then not recognize it, and should open the Import Wizard, where you
can then stipulate Text.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I am trying to import a comma delimited text file which contains among
other information, a numeric part number (ie 00123). I surround the
part number with quotes and import indicating use quotes a text
qualifier. No mater what I do, Excel still refuses to import this data
as text, it always converts it to a number (123). This is an issue
because this Excel file will be going into another program which will
be using that field in table relationships. Can't fix it after the
fact because all of the part numbers are different (00123, 0001.,
1234A, etc...) I have turned off all error checking under Options,
Error Checking. Has anyone experienced this before, or know of a
remedy. Checked out Microsoft for info, to no avail.
 
Back
Top