ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel truncates barcode being scanned in (https://www.excelbanter.com/excel-discussion-misc-queries/149996-excel-truncates-barcode-being-scanned.html)

BD Shipping

Excel truncates barcode being scanned in
 
We are trying to scan in bar code numbers using a bar code reader.
Excel however is truncating the last four digits of the barcode.

Peo Sjoblom

Excel truncates barcode being scanned in
 
Excel has 15 digits numerical precision and everything beyond that will be
truncated, try to preformat the range where you scan to text as opposed to
general or numbers



--
Regards,

Peo Sjoblom



"BD Shipping" <BD wrote in message
...
We are trying to scan in bar code numbers using a bar code reader.
Excel however is truncating the last four digits of the barcode.





All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com