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
Bookmarks