Number
  • 18 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Number

  • Dark
    Light
  • PDF

Converts the value to a number, if it is not already a number. Numeric texts are parsed. Any other values, and invalid texts, result in null value.

Function signature

NUMBER(value: String|Number) => Number
Parameter Description
Value Value to convert to a number

Examples

Formula Return value
NUMBER("123") 123
NUMBER("-0896") -896
NUMBER(-4.8) -4.8

Was this article helpful?

What's Next