Prev: Referencing objects inside of a loop
Next: Crane model in Excel
From: Mike on 7 Apr 2010 19:09
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.
From: Gord Dibben on 7 Apr 2010 20:03
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 <Mike(a)discussions.microsoft.com>
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.

 | 
Pages: 1
Prev: Referencing objects inside of a loop
Next: Crane model in Excel