11 digits
 

I am using a cordless scanner to scan barcodes into Excel. The barcodes have
12 digits but my Point Of Sale system only reads the first 11. To import
this information into my POS system I need to drop the last digit. Also some
of the numbers have a leading zero which I must keep as well. Any help on
how to do this would be greatly appreciated.

11 digits
 

Matt wrote:
I am using a cordless scanner to scan barcodes into Excel. The barcodes have
12 digits but my Point Of Sale system only reads the first 11. To import
this information into my POS system I need to drop the last digit. Also some
of the numbers have a leading zero which I must keep as well. Any help on
how to do this would be greatly appreciated.


Not completely sure I understand your problem, but try this:

=LEFT(RIGHT(REPT("0",12)&A1,12),11)

11 digits
 

If your data comes as text:

=LEFT(A1,11)

If it comes as a number:

=TEXT(INT(A10/10),"00000000000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Matt" wrote in message
...
I am using a cordless scanner to scan barcodes into Excel. The barcodes
have
12 digits but my Point Of Sale system only reads the first 11. To import
this information into my POS system I need to drop the last digit. Also
some
of the numbers have a leading zero which I must keep as well. Any help on
how to do this would be greatly appreciated.

11 digits
 

Hi Matt
Have you got a software for your scanner ?
Check out this site, there's more then one software.check Home page.
Do a Google search for Barcode software or Barcode readers, many sell software
you can buy.
Usually the first character is a start character and the last one is a CheckSum
character.
HTH
Johm
http://www.taltech.com/products/winwedge.html
HTH
John

"Matt" wrote in message
...
I am using a cordless scanner to scan barcodes into Excel. The barcodes have
12 digits but my Point Of Sale system only reads the first 11. To import
this information into my POS system I need to drop the last digit. Also some
of the numbers have a leading zero which I must keep as well. Any help on
how to do this would be greatly appreciated.