Carl
=MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11},1)))*3+SUMPRODUCT(--
(MID(E3,{2,4,6,8,10},1))),10),10)
is the formula for the UPC checkdigit (12 digits)
Just add digits 12 & 13 (to the even/odd sections)
=MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11,13},1)))*3+SUMPRODUCT(--
(MID(E3,{2,4,6,8,10,12},1))),10),10)
There are probably some on-line tools that you can use to check the
calculation...
To: [email protected]
From: "cmcmillan3" <[EMAIL PROTECTED]>
Date sent: Thu, 01 Jun 2006 12:56:23 -0000
Subject: [EDI-L] GTIN Generated from UPC
> Does anyone have a tool or know the math to create a GTIN based on a
> UPC code? I had a little utitlity that did this in Excel but I cannot
> find it. I need to create 3 GTIN's and am going crazy.
> Any help is appreciated.
> -Carl
>
>
>
>
>
>
> ...
> Please use the following Message Identifiers as your subject prefix: <SALES>,
> <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
>
> Job postings are welcome, but for job postings or requests for work: <JOBS> IS
> REQUIRED in the subject line as a prefix.
>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
> RSS feed is: http://rss.groups.yahoo.com/group/EDI-L/rss
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1572 (20060601) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
Earl Wertheimer
[EMAIL PROTECTED]
http://www.spe-edi.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Everything you need is one click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/OIFolB/TM
--------------------------------------------------------------------~->
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Access the list online at: http://groups.yahoo.com/group/EDI-L
RSS feed is: http://rss.groups.yahoo.com/group/EDI-L/rss
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
