- The leading zeros from item barcodes are stripped when I load a csv generated by WorldShare Reports into Excel
- WMS Reports
To avoid leading zeros being stripped from item barcodes:
- Export the file from Report Designer in csv format.
- Before importing into Excel, open a blank spreadsheet in Excel and format the column which will receive the item barcodes as a 'text' column.
- Load data from csv file into the spreadsheet.
This can also applied to other fields which have leading zeros e.g. ISBNs.