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.
| Both sides previous revisionPrevious revision | |||
| faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel [2012/05/31 11:41 (12 years ago)] – cliff | faq:barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel [2012/05/31 11:51 (12 years ago)] (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: | ||
| < | < | ||
| =IF(LEN(IF(LEN(A2)=10, | =IF(LEN(IF(LEN(A2)=10, | ||
faq/barcode_fix_routine_format_upc_11_12_digit_check_digit_checkdigit_excel.txt · Last modified: 2012/05/31 11:51 (12 years ago) by cliff