Ooops!

=ISNUMBER(1/RIGHT(A1))

Disregard. That fails if the rightmost char is a 0.

=ISNUMBER(-RIGHT(A1))

Or

=ISNUMBER(--RIGHT(A1))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=ISNUMBER(1/RIGHT(A1))

--
Biff
Microsoft Excel MVP


"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))