View original (French)

EAN-14 Barcode Control Code

AUDREY -  
zipe31 Posted messages 34620 Registration date   Status Contributeur Last intervention   -
Hello,

Regarding the super code provided by EDDY
Does anyone know how to do it in this case to obtain an EAN14 barcode?
With 13 characters to start with.

Thanks in advance!!!

Configuration: Windows / Chrome 78.0.3904.108

1 réponse

Réponse 1 / 1
zipe31 Posted messages 34620 Registration date   Status Contributeur Last intervention   6 500
 
Hello,
Regarding the awesome code given by EDDY
Where is that? What are you talking about?

We're not psychics ;-\

--
_______________________________ ☯ Zen my nuggets ☮ _____________________________
Do something for the environment, close your windows and adopt a penguin… ????
0
AUDREY
 
Oops!
Here's what he proposed for the EAN13:



If you have the first 12 characters of your EAN code in cell A1, you can use the following formula in B1:

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

It performs the necessary calculation…

And to get the full EAN in cell B2 for quick copy/paste, the following formula will be useful:

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

If you have a list of codes, just place the formula in the first cell and drag the fill handle down…
-1
zipe31 Posted messages 34620 Registration date   Status Contributeur Last intervention   6 500 > AUDREY
 
Is it for Excel?
0
AUDREY > zipe31 Posted messages 34620 Registration date   Status Contributeur Last intervention  
 
Yes, in Excel, I have a column A of EAN 13 barcodes and I would like to apply a formula that will give me the corresponding EAN 14 in column B.
0
zipe31 Posted messages 34620 Registration date   Status Contributeur Last intervention   6 500 > AUDREY
 
So I'm moving to the appropriate forum...
0