Failed Comparison... why?

[shelfish]

Changing the format of the cell does NOT necessarily change how Excel views it.

But since you write the characters are the same and it appears that, contrary
to my original guess, the values are all numbers, then I suspect that the
problem is that one is TEXT and the other General or Number.

Changing the format AFTER the cell has been filled with data will NOT change
how Excel views that cell.

So try this and see what you get:

=ISTEXT(Sheet2!A1)
=ISTEXT(B1)

--ron

istext didn't seem to work but I went back the the TRIM function
mentioned above and that seems to do it. I worked it into the MATCH
formula in column B.

On another note, I also worked into the macro
RANGE('C:C").NUMBERFORMAT = "@"

It had no effect.

Thanks for all the help....all.

S.

 

[Ron Rosenfeld]

istext didn't seem to work but I went back the the TRIM function
mentioned above and that seems to do it. I worked it into the MATCH
formula in column B.

That's not very helpful.

I don't know what "istext didn't seem to work" means.

Formula didn't calculate? If so, then you entered it as text and/or you have
calculations set to manual.

Formula returned an error message, rather than TRUE or FALSE? If so, what is
the error message?


--ron