User Tools

Site Tools


faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel [2012/05/31 11:41]
cliff
faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel [2012/05/31 11:51] (current)
cliff
Line 6: Line 6:
 If we place a special formula in excel we can have excel clean up barcodes that are 11 characters in length. This particular routine adds a 0 in the front of 10 character barcodes and then calculates the check digit. This was a specific case scenario as it accounts for the most common scenario we run into which is excel removed a leading 0. If the supplier of the barcodes did not provide the correct 11 or 12 digit barcode you must get the correct barcode before continuing. ​ If we place a special formula in excel we can have excel clean up barcodes that are 11 characters in length. This particular routine adds a 0 in the front of 10 character barcodes and then calculates the check digit. This was a specific case scenario as it accounts for the most common scenario we run into which is excel removed a leading 0. If the supplier of the barcodes did not provide the correct 11 or 12 digit barcode you must get the correct barcode before continuing. ​
  
 +REQUIREMENT:​ The barcode must be in column A, and you must know how to place the formula into excel and fill down. (Note: start at row 2, and I suggest placing the formula in column B.
 <​code>​ <​code>​
 =IF(LEN(IF(LEN(A2)=10,​0&​A2,​A2))=11,​IF(LEN(A2)=10,​0&​A2,​A2)&​ =IF(LEN(IF(LEN(A2)=10,​0&​A2,​A2))=11,​IF(LEN(A2)=10,​0&​A2,​A2)&​
faq/barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel.txt ยท Last modified: 2012/05/31 11:51 by cliff