널드컴 Posted February 24, 2018 Share Posted February 24, 2018 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 Link to comment Share on other sites More sharing options...
Hyun Woo Posted February 27, 2018 Share Posted February 27, 2018 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. Link to comment Share on other sites More sharing options...
Garrick Rogers Posted March 2, 2018 Share Posted March 2, 2018 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now