IsNumeric Function

Checks to see if a string expression can be evaluated as a number. The entire string must represent a number for a True value to be returned.

IsNumeric (String)

Parameters

String  -  (Input, expression, Required)

Specifies the string to be evaluated.

Return Value

Returns True if the entire string can be converted to a number, otherwise False.

Examples

IsNumeric (“”)	Returns False
IsNumeric (“-1.2”)	Returns True
IsNumeric (“1.2abc”)	Returns False
IsNumeric (Null)	Returns False
IsNumeric (Error)	Returns False

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

UBound Function | IsArray function | IsDate function | IsEmpty function | IsError function | IsNull function | IsNumeric function | IsSpaces function | IsURL function

---

© 2004-2021 looksoftware. All rights reserved.