View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Removing a check digit

"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?


=LEFT(A1,LEN(A1)-1)
--
David Biddulph