USB Barcode scanner and formatting help

**coolguy55220** · 02-24-2010, 12:09 PM

Hey guys,
I have a lottery report which you need to enter the # of the current ticket, so it can keep track of how many you sold daily. We manually enter the #'s in everyday. These tickets have barcodes, but the barcodes contain extra digits, all i need are the last 3 digits from the barcode.
Is there a way i can utilize a USB barcode scanner and format a cell so that each i can scan the barcode into a cell and it will only take the last 3 digits that are required?

BTW, i am assuming a usb barcode scanner will work with excel, just scan and it will automatically paste the data in the current cell?

Thanks for your help.

**masteff** · 02-25-2010, 03:28 PM

if your scan from the ticket was in A1, then you could use: =VALUE(RIGHT(A1,3)) to get the last three digits as a number.

generally speaking, yes, you can use the scanner to input direct to excel. you'll just have to experiment with it.

**coolguy55220** · 02-26-2010, 11:10 AM

Originally Posted by masteff

if your scan from the ticket was in A1, then you could use: =VALUE(RIGHT(A1,3)) to get the last three digits as a number.

generally speaking, yes, you can use the scanner to input direct to excel. you'll just have to experiment with it.

I figured i could do that. I attached a picture of what the file looks like, as you can see in it, the white column are the lottery #'s and grey's are the formulas to calculate the sale. Those formula's are complicating as it is, so i dont want to add VALUE(RIGHT(A1,3)) in every spot. Also i want the ticket # to show up in the whites, not the whole bar code.
I was thinking, maybe that i could scan em all in w/ the scanner, and then write a macro that would use the column of the cell i select and use VALUE(RIGHT(A1,3)) on each cell until the end of tickets which is at # 102. Or maybe just select the columns manually and then use the macro that will change it from barcode to last 3 digits using that function.

Would that be easy to do?