View original (French)

EAN-14 Barcode Control Code

AUDREY -  
zipe31 Posted messages 34620 Registration date   Status Contributor 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 answer

  1.
    zipe31 Posted messages 34620 Registration date   Status Contributor Last intervention   6 501
     
    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
    1. 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
      1. zipe31 Posted messages 34620 Registration date   Status Contributor Last intervention   6 501 > AUDREY
         
        Is it for Excel?
        0
      2. AUDREY > zipe31 Posted messages 34620 Registration date   Status Contributor 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
      3. zipe31 Posted messages 34620 Registration date   Status Contributor Last intervention   6 501 > AUDREY
         
        So I'm moving to the appropriate forum...
        0