of course there is an on-line resource!
http://www.gs1.com/productssolutions/idkeys/support/check_digit_calculator.html
--- Earl Wertheimer < wrote:
> 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:
> From: "cmcmillan3" <
> 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
>
> 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
>
>
>
>
>
>
>
>
Brian Lehrhoff
EDI Consultant
201-913-4506
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Cart
