How to Format Barcodes in Spreadsheets and CSV files
Because many barcodes may begin with zeros or other characters you may encounter difficulties when entering or scanning them onto your spreadsheet if the cells have been defined (by default) as numeric (Excel will remove leading zeros).