Excel truncates barcode being scanned in

B

BD Shipping

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.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating Number Series 3
Automation of scanned file storage based on content 0
Barcode Scanner 0
setup and useing a barcode reader 1
text box that will leave only the last 4 digits entered 0
Scroll does not show preview 0
How can one append information in an Excel spreadsheet to a barcod 0
auto move down after barcode data entery 1

Top