faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel

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

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