TONUMBER
converts value to number; unparseable text returns default when given, else #VALUE! · a deepcalc original · no excel equivalent · no sheets equivalent
signature
TONUMBER(text, [default_value])
returns: number
| argument | required |
|---|---|
| text | required |
| default_value | optional · defaults to 0 |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=TONUMBER("123.45") 123.45 | A | |
|---|---|
| 1 | 10 |
fx
=TONUMBER(A1, 0) 10 errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #VALUE! | =TONUMBER("alpha") |
related
- FROMBYTES converts byte array to integer
- GENERATEID generates unique ID with prefix and random suffix
- HASH hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- IMAGE shows an image from a url — the browser loads it, the engine does not fetch
- ISIN checks if value is in a range or comma-separated list
- RANDOMCHOICE random pick from a range (with replacement); count > 1 spills a column