Barcode Check Digit Calaculation

I have list of 65000 EAN13 Barcode numbers for which I need to calculate the check digits. does anyone know if there is an excel formula for doing this? Idealy I would like to have all the 12 digit codes in column 'A' and then in column 'B' the completed 13 digit code which have the check digit added. My first 12 digit code number in the sequence is 501790100001.

Thanks

Hi pjoaquin, many thanks for the help. The second formula you gave seemed to work just fine to calaculate the check digit. I got the final result as follows:

Cell A1 : 12 digit EAN13 barcode number
Cell B1 : The second formula you gave to calculate the check digit
Cell C1 : =CONCATENATE(A1,B1)

I then converted column 'C' to a number via: Data - Text to columns - Delimited - Finish

Probably not the quickest way as my Excel knowledge is limited, but it got me where I needed to be.

Once again thanks for the help

Rich

Nice work by Paul.

You should be able to change the formula in B1 to eliminate the other steps:

=(A1 & LOOKUP(MOD(3 * SUMPRODUCT(--MID(A1,ROW(1:12), 1) *
(MOD(ROW(1:12),2) = 0) ) + SUMPRODUCT(--MID(A1,ROW(1:12), 1) *
(MOD(ROW(1:12),2) = 1) ), 10), {0,1,2,3,4,5,6,7,8,9}, {0,9,8,7,6,5,4,3,2,1}) ) + 0

Hi, you can follwing the below steps to calculate the check digit, it's easy in fact.
http://www.keepautomation.com/produc...es/ean_13.html

Hi, I've seen an article about EAN 13 barcode checksum manual calculation on BarcodeIsland.com.
Any way, there're lot of free excel barcode generator solutions that can calculate the check digt, like Excel EAN/UPC barcode genrator or this barcode creator.

Great!!!!!! Nice work Paul. Its help me alot. Thanks again

nice work. and what about EAN8? does anyone have a solution for the check digit ?

This does not work for me unfortunately. I'm following exactly the steps Paul described, but it gives me formula error. the post is from 2008....5 years later I can imagine that things may have changed?

does anyone have a working excel formula that does generate a list of the EAN code with the control/check number ?

Please let me know, I need this urgently

thanks for sharing this method, i was wondering can excel ean 13 barcode generator control automatically output check digit for us. if so that would be so much easy
we don't need to calculate anymore. is it possible?

Hi,
How "late" am I in order to present a slightly different formula ?

=A1&MOD(10-MOD(SUM(--MID(A1,{12,10,8,6,4,2},1))*3+SUM(--MID(A1,{11,9,7,5,3,1},1)),10),10)
-----
Elm