Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When does ISNUMERIC point to a number?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IsNumeric with array or range | New Users to Excel | |||
opposite of IsNumeric | Excel Discussion (Misc queries) | |||
opposite of IsNumeric | Excel Programming | |||
IsNumeric Test | Excel Programming | |||
Not IsNumeric not working - or is it me? | Excel Programming |