Removing a check digit

[cwd58]

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?

[Bob Phillips]

=left(a1,13)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"cwd58" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Ardus Petus]

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

HTH
--
AP

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

[David Biddulph]

"cwd58" <[email protected]> wrote in message
news:[email protected]...
>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