Jump to content

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


널드컴
 Share

Recommended Posts

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

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

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...