Determines if a string contains a numerical value.

str—A string or an array of strings to check for numerical characters.

If str represents a floating point or integer value, 1 (true), otherwise 0 (false). If str is an array, the returned value will also be an array where result(i) corresponds to str(i).

Integer—If set and nonzero, returned value is true only for integer values, not floating point values. The default is to succeed for floating point or integer values.

Can not deal with a string containing multiple numbers (these test false)—Use the STRSPLIT function or something similar to break these into a string array.

Does not detect integers of the form xxxI, xxxL, or xxxB, or valid forms of Hex or Octal values. Spaces and tab characters are allowed (surrounding a valid number).

STRSPLIT