deepcalc
DocsTONUMBER

TONUMBER

View as markdown/docs/functions/tonumber.md Ask Claude about this pageOpens Claude with this page's address

Converts value to number; unparseable text returns default when given, else #VALUE!

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Number

Examples

=TONUMBER("123.45")
Result 123.45
=TONUMBER(A1, 0)
A
1 10
Result 10

Syntax

TONUMBER(text, [default_value])
text
text required
default_value
number optional defaults to 0

Errors

#VALUE!
=TONUMBER("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.