Function Description
| Category | Description |
|---|---|
| Function Syntax | TONUMBER(text) |
| Function | Converts text to a number. If the text cannot be converted to a number, the function returns #VALUE!. |
| Parameter | text: the text to convert to a number |
| Number of Parameters | 1 |
| Parameter Type | Text |
| Return Value Type | Number |
The following table provides simple formula examples.
| Formula | Result |
|---|---|
TONUMBER("123") | 123 |
TONUMBER("123.56") | 123.56 |
TONUMBER("Hello") | #VALUE! |
Example
After you process field values with a formula, the expected output is a numeric type, but the actual output is a text type.
In this case, you can use the TONUMBER function in the outermost layer to convert the text type to a numeric type.
