View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.