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.