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 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 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.
Clarity has the experience, industry knowledge and grower specific tools and solutions to ensure a grower's new website is a solid investment today and in the future.
Learn MoreA website from Clarity Connect provides the tools needed to reach your business goals.
Learn More