USB Barcode scanner and formatting 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?