The check digit control character is that character, as this last number to the right of a barcode (bar code) needed to validate the reading.
The calculation procedure is quite simple
- 3 Multiply all the numbers in the odd positions (starting from right) and add them together (value A)
- Add all the numbers in the even positions (from right), (B value)
- The control code is obtained by subtracting the ten top of the total sum (A + B) the same sum (eg A + B = 114, the check is 120-114 = 6)
Excel spreadsheet for calculating the check digit on EAN13 (Excel 2007, 97-2003)
More information and online forms for calculation: GS1
November 10, 2008 24:43
Sorry but it should be 13 characters including the checkdigit? because '
November 10, 2008 13:07
Yes, 13 characters (including check) for EAN13, if you download the sample in Excel format, which was the main part of the article, you'll see that there are 13 including the check digit. Your provider and change the image to avoid possible misunderstandings, thanks for the tip.
October 10, 2009 09:44
Only one word THANKS!
I have saved your file
November 18, 2009 15:00
you could put this calculation into a function of the barcode so that it can control the exact type of a barcode in a cell of a page work?
Thanks
November 18, 2009 16:15
Hello Peter,
certainly if you download the Excel file for example is easy enough to create what you ask for a few changes. Just compare the last digit of the cell where you type with the check digit created by the formula.
December 3, 2009 09:17
Great!
December 29, 2009 15:54
how to do the same string for the check number with lotus leaf?
the consideration of the MID function in excel is in HALF @ lotus. but he considers the cell as a label, and then does not do the operations. anyone can help me?
thanks
fabio
February 15, 2011 22:51
Hello, please help me?! I purchased some time EAN bar codes for work on this site http://www.ean13-code.com/indexi.html I must say that I feel good, but you think that there may be alternatives? I thank you in advance for your response.
February 15, 2011 22:58
You can buy from Indicod http://indicod-ecr.it/ company prefix.
April 4, 2011 17:24
Hello I have a code like:
00-007442658-99-8
how do I get an excel of 100 consecutive complete barcode check digit?
Mirko
April 4, 2011 17:56
First you have the bar code without check digit (the one you posted I think it is a product key, certainly not a bar code so you do not do anything), then in Excel you can generate the check digit.
If barcodes are to be used to market products to be purchased (Indicod-Ecr).
May 27, 2011 10:31
Thank your file was providential
Hello
February 27, 2012 14:28
GRAAAAAAAAAZIEEEEEEEEEEEEE
March 8, 2012 13:25
I found solution to the problem of calculating check digits for 13 ean useful in your log. Thank you.
I need 'of the same formula for ean 8. and 'can have risocntro. Thank you in advance.
gc
March 8, 2012 14:54
Hello John,
currently do not have time to do it, I'm sorry, but I suggest you download the file for editing and for EAN13 EAN8.
If you can wait write again in a 10/15 days.