Importing a Text file into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import a text file into Excel, leading zeros in columns are truncated.
Has anyone else seen this? Is there a cure?
 
Choose Data/Get External Data/Import Text File...

navigate to your file, click OK. Select Delimited in the Text Import
wizard, click OK, Select your delimiter, click OK, Select the column(s)
of data you want to preserve as text and click the Text radio button.
Click Finish.
 
Try formatting the columns as Custom before importing the
text file. For example, if you have a 6-digit vendor
number in a column, format that column as Custom, 000000.
That should force the preceeding zeros when the data comes
in. HTH.
 
When importing with the text import wizard (I guess that's
what they call it) there's a screen where you can format
your columns. Set the column with the leading zeros as
text. I see this issue on a regular basis. Are you
working with CAS#s by any chance?
 
-----Original Message-----
When I import a text file into Excel, leading zeros in columns are truncated.
Has anyone else seen this? Is there a cure?
.
Click to expand...
Highlight your column/cell and go to "Data", "Text to
Columns".
 
Back
Top