The cell A2 contains the TEXT "ABC1234" The rightmost character,
RIGHT(A2,1) is a "4" which is TEXT not a number.
If you want to test that to see if it is something that can be converted to
a number, you can also use =ISNUMBER(VALUE(RIGHT(A2,1)))

Tyro

"doyree" wrote in message
...
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))