View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Removing a check digit

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

HTH
--
AP

"cwd58" a écrit dans le message de news:
...
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?