ISNUMBER

See also A-Z Spreadsheet Function List

Description Determines if the specified expression is a number.

Syntax ISNUMBER(expression)

expression is any expression.

Remarks If the expression returns a number, True is returned. Otherwise, False is returned. If expression returns a number represented as text (e.g., “12”), False is returned.

See Also ISBLANK , ISERR , ISERROR , ISLOGICAL , ISNA , ISNONTEXT , ISREF , and ISTEXT functions

Examples ISNUMBER(123.45) returns True

         ISNUMBER(“123”) returns False