Support  »   Other Support Topics  »  

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 separated with a '|'.  Click through the images at the left 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 separated 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.