Forum Discussion
Strange GS1 barcode reading error on Excel (but not on Word!)
- I guess the codes are converted to scientific notation because they are more than the allowed maximum 15 significant digits in Excel. I hope that the GTIN, Lot Number, and Expiry Date could be exported to Excel in separate columns.
GTIN means Global Trade Item Number. For GTIN-14, it means that the GTIN consists of 13 digits plus 1 check digit, which results in a total of 14 digits. GTIN-14 has the maximum number of digits among all GTINs. There is no such thing as GTIN-15 or other GTINS consisting of more than 14 digits.
Thanks.
I actually was pretty sure it was something in that direction, since after all we were talking about product bar codes, but was seeking to make a point...insider language tends not to accomplish what language is intended to do, i.e., communicate.
More important, given your knowledge of Excel and its limits, do you have any idea as to why 5% of the codes, when scanned, turn into scientific notation? There has to be something distinctive about those codes, assuming it happens consistently and not randomly.
- I guess the codes are converted to scientific notation because they are more than the allowed maximum 15 significant digits in Excel. I hope that the GTIN, Lot Number, and Expiry Date could be exported to Excel in separate columns.
- Thank you for your input. We will check and see if that helps.
