deepcalc
DocsTO_PURE_NUMBER

TO_PURE_NUMBER

View as markdown/docs/functions/to-pure-number.md Ask Claude about this pageOpens Claude with this page's address

Strips formatting and returns the underlying number.

  • Excel: No equivalent
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=TO_PURE_NUMBER(42)
Result 42

Syntax

TO_PURE_NUMBER(value)
value
number required

Errors

#VALUE!
=TO_PURE_NUMBER("alpha")
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column.