Once upon a time, I wrote a formula to calculate the EAN13 barcode check digit in excel. I happened to mention it on a mailing list and it seems some people are looking for just such a thing and they email me asking about it (which is rather nice).
Anyway, I thought I would post the formula here for public digestion.
It’s not pretty and I believe there is probably a much nicer way of doing it… I just don’t know that way. So here it is:
A2 is cell containing the number of the barcode.
=MOD(10-MOD(MID(TEXT(A2,0),1,1) * 1
+ MID(TEXT(A2,0),2,1) * 3
+ MID(TEXT(A2,0),3,1) * 1
+ MID(TEXT(A2,0),4,1) * 3
+ MID(TEXT(A2,0),5,1) * 1
+ MID(TEXT(A2,0),6,1) * 3
+ MID(TEXT(A2,0),7,1) * 1
+ MID(TEXT(A2,0),8,1) * 3
+ MID(TEXT(A2,0),9,1) * 1
+ MID(TEXT(A2,0),10,1) * 3
+ MID(TEXT(A2,0),11,1) * 1
+ MID(TEXT(A2,0),12,1) * 3,10),10)
I basically convert the text to string to pull out the digit I want to manipulate, then apply the formula to that digit.
I’d love to hear from anyone who knows a more elegant way of doing it.
Category: General
-
EAN13 Barcode checkdigit calculation in Excel
-
James5 – Organic Expo: Overview (with pictures!)
James5 saw us at the Organic Expo.
-
Natalija creates:
Natalija is in the mood for Cocolo Dk Chocolate with Peppermint Crisps & The sound of silence
-
Stop the Traffik: White Chocolate and Almond Tartufi « a whisk and a spoon
Stop the Traffik have done a nice recipe using Cocolo chocolate
-
Whitecliffs General Store: Cocolo Chocolate and Organico olives…
Whitecliffs General Store are now carrying our chocolate.
-
Loco for Cocolo Chocolate
Yasmin is Loco for Cocolo Chocolate
-
The Age Blogs about Cocolo
The Age Blogs mentions Cocolo
-
blameless chocolate
blameless chocolate have also tried Cocolo and they like it.
-
Mocktale mentions Cocolo
Menu for hope mention’s Cocolo in their article about putting together a Fairtrade hamper