Thread: 11 digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default 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.