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.