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.
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.