View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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?