Excel dropping leading zeros on barcode

Follow
When excel drops leading zeros on barcodes this is usually excel treating the barcode as a numeric value instead of text value.

Solution
Open the file with notepad and re-save as a text file (.txt extension) and then open the file with excel.  When prompted specify each field to be text during the import process and the values will be imported as text.

Have more questions? Submit a request

Comments

Powered by Zendesk