On Sun, 7 Nov 2004 01:00:01 -0800, "SiouxieQ"
wrote:

Thanks Biff,

The data from one program comes through as follows:

89101
123456

From the program that contains the ID's I use the right function on they
come through as follow with the last 6 digits representing the inventory code

999-000-00089101
232-987-00123456

The right function column returns me similar numbers to that from the first
database, but to get all codes I have to lookup 6 numbers which means my 5
digit codes have a 0 in front which I haven't found a way of getting rid of.

I couldn't figure out a way of formatting this, and drew a blank on other
ways around it.Any ideas for things to try out?

Cheers,

Sue


I'm not sure if you want the zero or don't want the zero.

If you merely want to compare the last six digits of each code, and if the code
from the one program is in A1 (with the 'string' code in B1), then:

=-RIGHT(B1,6)=-A1

will give TRUE if the last six digits are the same.

The (-) coerces both to be numbers; although both negative, it really doesn't
matter for a comparison.


--ron