Barcode scanning

Question

I am scanning barcodes into excel, and most are ok, but one type changes the numbers once I leave that cell. i.e if I scan 6372901365460000561001, it changes to 6372901365460000000000. I have the format cell set on "number with 0 decimal places". I actually only need the numbers 1365460000561 from this example, so not sure if I can shrink which numbers it reads

Answer 1

Annette10,

clearly you are not going to do math with that number.  The problem is that when excel stores numbers, it only maintains 15 digits of precision.  What you need to do is format your cells as text before you scan in the number.  Excel can hold up to 32K characters in a cell so your scanned in text string will be retained. 

If you want to build a userform or something to scan your number into, you could then pull out the the left 13 characters, but I don't see a practical solution to being able to do that by scanning directly into a cell. 

A userform would require VBA code by the way.

--

Regards,

Tom Ogilvy