Logo Docs
Logo Docs

ISNUMBERTEXT

Returns TRUE if the text represents a number, FALSE otherwise

Usage

ISNUMBERTEXT(text)

Parameters

text

(Required) A text

Examples

Example With these variables Result

ISNUMBERTEXT(“123”)

 (None)

TRUE

ISNUMBERTEXT(123)

 (None)

FALSE

ISNUMBERTEXT(val)
val is "-12.3"

TRUE

ISNUMBERTEXT(“123abc”)

 (None)

FALSE

ISNUMBERTEXT(“”)

 (None)

FALSE

More information

ISNUMBERTEXT returns FALSE when the value is a number (and not a text containing digits).

If ISNUMBERTEXT returns TRUE, then you know the NUMBER function would succeed in providing a number with that text.

See also