NUMBER

Returns the number that is represented by the text, or report an error

Usage

NUMBER(numberlike_text)

Parameters

numberlike_text

(Required) A text representing a number

Examples

Example With these variables Result

NUMBER(“123”)

(None)

123

NUMBER(val)

val is "-12.3"

-12.3

NUMBER(“123abc”)

(None)

ERROR

NUMBER(“”)

(None)

ERROR

More information

Can also receive a number, which will be returned as-is.

See also