Removing a check digit
=left(a1,13)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"cwd58" wrote in message
...
I want to remove the check-digit from a list of barcode numbers. So
33609005000160 will be changed to 3360900500016.
Can this be done in Excel or Access?
|