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

[Guest]

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.

 

[Niek Otten]

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

http://groups-beta.google.com/group..._doneTitle=Back+to+Search&&d#4e7ebfb311cbcad4


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel