ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UPC Numbers (https://www.excelbanter.com/excel-programming/441422-upc-numbers.html)

Mike

UPC Numbers
 
I was wondering if anyonr new how to determin if a 11 digit upc number needs
to be turned into a 14 digit number. I receive a EDI file from our
distributor with 11 digit upc numbers and i no how to caculate the check
digit but having no luck trying to detemin if upc number needs to be 14
digits.
Example I know this number 03330071814 needs to be 14 digits cause
00033300718146 is whats on the product.

Can someone maybe shed some light.

Gord Dibben

UPC Numbers
 
You must have a list of the 14 digit numbers somewhere in order to
cross-check.

Where would that list be located?


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 16:09:01 -0700, Mike
wrote:

I was wondering if anyonr new how to determin if a 11 digit upc number needs
to be turned into a 14 digit number. I receive a EDI file from our
distributor with 11 digit upc numbers and i no how to caculate the check
digit but having no luck trying to detemin if upc number needs to be 14
digits.
Example I know this number 03330071814 needs to be 14 digits cause
00033300718146 is whats on the product.

Can someone maybe shed some light.




All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com