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