ISNUMBER

The ISNUMBER function tests a text object to determine whether it contains all numeric characters.

Syntax:
ISNUMBER (single-text-expression)
Meaning:
ISNUMBER (text_to_test)
Returns:
This function evaluates to a Boolean "true" or "false" and should only be used as a conditional expression within a logical function.

If text_to_test contains only digits (for example, 0-9), ISNUMBER evaluates to "true".

If text_to_test contains other than digits, ISNUMBER evaluates to "false".

Examples

  • IF(ISNUMBER("1")

    Returns "true"

Related functions

  • ISALPHA
  • LEAVEALPHANUM
  • ISLOWER
  • LEAVENUM
  • ISUPPER
  • LEAVEPRINT
  • LEAVEALPHA