Forum Discussion
Solved
Strange GS1 barcode reading error on Excel (but not on Word!)
Hello, We are a small biomedical company that is testing new product labels & GS1 barcodes to comply with the upcoming European and American regulations for Unique Device Identifiers (UDIs). ...
- 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.
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.
