ISNUMERIC function

Synopsis
This function returns whether the specified string can be converted to a numeric value.
Variations
ISNUMERIC(String)
Returns whether the specified string can be converted to a numeric value.
Details | Examples | Details and examples
Parameters
String

Specifies the string to read.

Supported types: String.
Returns
Returned types: Boolean.
Examples
1.

The following example returns True.

ISNUMERIC("123.450")
2.

The following example returns False. Note the final character is the letter 'O', not the number '0'.

ISNUMERIC("123.45O")
3.

The following example returns True. Note the final character is a blank space.

ISNUMERIC("123.450 ")
4.

The following example returns False. Note the final character is a comma.

ISNUMERIC("123.450,")