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
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
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
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
I think shg's formula just need a little text tweaking.
Try the following formula for the 11 digits in cell A1:
For a code of '74702813169'Please Login or Register to view this content.
Complete barcode: '747028131698' which matches the OP's results from 2008.
Lewis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks