Functions
TO_PURE_NUMBER
Strips formatting and returns a plain number
Try it
When to use it
When should I use TO_PURE_NUMBER?
Use TO_PURE_NUMBER to strip any currency, percentage, or date formatting from a value and return a plain number you can use in arithmetic.
Used in
Syntax
TO_PURE_NUMBER(value)Examples
=TO_PURE_NUMBER(42) // => 42
=TO_PURE_NUMBER(0) // => 0
=TO_PURE_NUMBER(-7) // => -7