hi
what you see on the screen may not always be what you think you're seeing.
you are seeing a 4 but xl sees it as text.
any cell with letters and number in it is automaticly classed by xl as text.
take the formula =right(A2,1) and paste it as values. text
also this formula =type(right(A2,1)) retuns 2 which is text.
so you are getting false because it's not "defined as number" by xl.
if you want it to be true then
=ISNUMBER(VALUE(RIGHT(A2,1)))
the value function converts it to a number.

by the way....uh....what are you trying to do?

Regards
FSt1
"doyree" wrote:

hello,
i'm not sure why i'm not getting "false" from below formula.
could someone tell me why and how i can get "true"?
thanks much!!~!!


A
ABC1234

=ISNUMBER(RIGHT(A2,1))