+ Reply to Thread
Results 1 to 4 of 4

Creating a check digit for GTIN 12

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    Sussex, New Jersey
    MS-Off Ver
    Excel 2013
    Posts
    2

    Creating a check digit for GTIN 12

    I have 508 items I need to create a UPC number for using a GTIN 12 calculation as the SKU's are 11 digits long. Any help on a an excel formula would be great.

    Thanks

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Creating a check digit for GTIN 12

    See the following post answered by 'shg' six years ago.
    http://www.excelforum.com/excel-gene...igit-help.html

    If this solves your problem, please go to that post, and click on the 'Add Reputation' for 'shg'.

    Lewis

  3. #3
    Registered User
    Join Date
    04-22-2014
    Location
    Sussex, New Jersey
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Creating a check digit for GTIN 12

    I saw that post and tried the formual but could not get it to work. I have my SKU number is column A and put the formula in column B and it just gave me a value error

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Creating a check digit for GTIN 12

    I think shg's formula just need a little text tweaking.

    Try the following formula for the 11 digits in cell A1:
    Please Login or Register  to view this content.
    For a code of '74702813169'
    Complete barcode: '747028131698' which matches the OP's results from 2008.

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to add check digit to 6 digit number string...
    By unclejemima in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2013, 04:19 PM
  2. Macro to force format and check barcode check digit
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2009, 10:27 AM
  3. GTIN Barcode Check Digit Help
    By brohlfs in forum Excel General
    Replies: 7
    Last Post: 05-15-2009, 11:17 AM
  4. Creating a check digit
    By Patrick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2006, 01:25 PM
  5. [SOLVED] Creating a Check Digit
    By Ilan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2005, 08:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1