Support » Other Support Topics »
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.