Based on the instruction for calculating a MOD 10 check
digit at this website,

http://www.morovia.com/education/utility/upc-ean.asp

you could use this formula:

=10-MOD(SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&ROUNDUP(LE N
(A1)/2,0)))*2-1,1)+0)*IF(ISODD(LEN(A1)),3,1)+SUMPRODUCT
(MID(A1,ROW(INDIRECT("1:"&INT(LEN(A1)/2)))*2,1)+0)*IF
(ISODD(LEN(A1)),1,3),10)

HTH
Jason
Atlanta, GA

-----Original Message-----

Does anyone know how to generate a unique card number
based on a
previously existing number? I'm trying to create a 16
digit Check
number by only given the first 15 digits. I've been to
this site:
http://www.beachnet.com/~hstiles/cardtype.html to use
the Excel spread
sheet file and it doesn't give me the info I need. Any
help is
welcomed.

Thanks,
John


--
Union70
.