Macro for using a Barcode scanner

Hello all I have a quick question I have bought a barcode scanner to hopefully make entering bills a bit quicker and more accurate, but I cannot get it to read the correct amount from the bills and input into an excel file.


The vales of the bill I want to enter is 25.27

The whole barcode is 620997830109120000000252700000001209210388072652 but what I want entered is only the 25.27 in the middle of the barcode as this is the value of the bill I need to enter.


When I use the scanner in word the whole barcode of 620997830109120000000252700000001209210388072652 is read so it seems that there is no problem reading the barcode, but just getting excel to enter the value of the bill.


I think all that is needed is a macro that knows where the data will be and can discard the numbers that I do not need, but I cannot work out how to do this ?

Any help/advice would be much appreciated.

I look forward to any replies, help, or points in the right direction.

Thanks a lot I will give it a go and let you know the outcome.

I tried the formula and it doesnt work, by the way I forgot to mention that in excel the barcode is scanned as 6.20998E+47 as it seems excel cannot deal wth the large number of the barcode which is 620997830109120000000252700000001209210388072652

Sorry to be a pain but my macro skils are extremely poor, could you run through step by step how to record that macro?

Thanks

Ben

Hi thanks but how I do I record the Macro? Could you possibly tell me how to do this step by step?

thanks Ben

Sorry, it isn't a recorded macro, it comes out of my mind (with what I learned in this Forum )