Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
Sample Usage
TO_PURE_NUMBER(50%)
TO_PURE_NUMBER(A2)
Syntax
TO_PURE_NUMBER(value)
-
value
- The argument or reference to a cell to be converted to a pure number.-
If
value
is a number or a reference to a cell containing a numeric value,TO_PURE_NUMBER
returnsvalue
with all formatting and interpretation removed. -
If
value
is not a number or a reference to a cell containing a numeric value,TO_PERCENT
returnsvalue
without modification.
-
Notes
-
TO_PURE_NUMBER
is similar to applying Format -> Number -> Normal from the menu bar, except that the Normal format includes commas denoting thousands, millions, etc. -
TO_PURE_NUMBER
is similar toN
, except thatN
returns0
for non-numeric values except forTRUE
which returns1
, whereasTO_PURE_NUMBER
returns the value passed without modification for all non-numeric types.
See Also
TO_TEXT
: Converts a provided numeric value to a text value.
TO_PERCENT
: Converts a provided number to a percentage.
TO_DOLLARS
: Converts a provided number to a dollar value.
TO_DATE
: Converts a provided number to a date.
N
: Returns the argument provided as a number.