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" <cwd58@discussions.microsoft.com> wrote in message
news:BF4F15CB-0410-4013-9AF1-52398CE86B63@microsoft.com...
> 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" <cwd58@discussions.microsoft.com> a écrit dans le message de news:
BF4F15CB-0410-4013-9AF1-52398CE86B63@microsoft.com...
>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" <cwd58@discussions.microsoft.com> wrote in message
news:BF4F15CB-0410-4013-9AF1-52398CE86B63@microsoft.com...
>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