Help file indicates ISNUMERIC(expression) evaluates the expression to a
boolean value (True or False) depending upon whether it is a number or
not. It seems a simple concept. But as he so often does, Tom Ogilvy has
dazzled me with the following revelations (which are verified):
isnumeric("02,21,14.23")
True
? isnumeric("35E1")
True
? isnumeric("34D1")
True
I would add that while Isnumeric("5abc") -- False
Isnumeric("5abc7")---True
The presence of the first and last characters being present in the
STRING is crucial.
I await enligtenment. TIA
--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=390472