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.

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)

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" <(E-Mail Removed)> wrote in message
news:5A93E811-1E05-4B44-B304-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
news:5A93E811-1E05-4B44-B304-(E-Mail Removed)...
>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.