The barcode starts with 0 (zero) in the item will be removed in the exported Excel.

[널드컴]

Hi.

When I export the item list in Excel, I just notice that if the barcode starts with 0(zero), the first digit 0(Zero) is removed in Excel.  

For instance, if a bardcode is "0234567", if appears as "23456" in exported Excel. If I edit other information beside a barcode, the barcode is replaced with the number without 0(zero).

Does anyone know how to download a barcode without missing 0(zero) or anyway not to edit the bardcode if I import Excel file?

 

Thanks  

[Hyun Woo]

Every digital table system inculude excel, doesn't recognize the '0' as the biginning number. I mean if you try to type '0333' then It will show only '333'
 

So you can try to make barcode as the text. but what I recommand you is "try not to start barcode with 0." It is the most simple way. 

[Garrick Rogers]

If you import the CSV file into excel and set the barcode column to text it will display the 0.  make sure you save the file as csv if you want to import it into the POS. otherwise it will drop the zero