Follow Us on Twitter Follow Us on Twitter Find us on Facebook

Importing a Pipe (|) Delimited File into Excel

to eliminte Excel deleting leading zeros

Excel will automatically drop a leading zero from a field when it's imported unless you import the file as a delimited file type.  In this example, the file is a 'pipe' delimited file which means each field is seperated with a '|'.  Click through the images at the right and read the captions to see how to import the pipe delimited file into Excel w/o dropping the leading zero.  Additionally, if you have a string of numbers seperated by commas (12,9,44) you'll want to do the same thing so Excel doesn't look at that column as a numeric value.

Click for previous Image Image 1 of 4 Click for next Image
Be sure to change the file type, before browsing for the Pipe Delimited exported file.

Be sure to change the file type, before browsing for the Pipe Delimited exported file.