Excel should have a function to verify the check digit on UPC num.
 

Standard UPC are 12 digits long. The last digit is a check digit based on
the previous 11 digits. It would be nice if you could have a function that
checked the accuracy of the UPC entered in a cell.

Bernard Liengme answered that one in August 2004. Here's Google's archive
link:

http://groups-beta.google.com/group/...7ebfb311cbcad4


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Brian S B" <Brian S wrote in message
...
Standard UPC are 12 digits long. The last digit is a check digit based on
the previous 11 digits. It would be nice if you could have a function
that
checked the accuracy of the UPC entered in a cell.