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)