@ToNumber (Formula Language)

Converts a value to a number.

Note: This @function is new with Release 6.


@ToNumber( value )



Text, number, or list thereof. A value that cannot be converted returns the error, "The value cannot be converted to a Number."

Return value


Number or number list. The value converted to a number.


If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements. A failure occurs if any element cannot be converted.

This function is useful for ensuring that a value has a number data type before using it in functions that require numbers as parameters.


  1. This example returns 20 and 40 in a list.
    @ToNumber("20" : "40")
  2. This example results in the error, "The value cannot be converted to a Number."
    @ToNumber("20" : "r")
  3. This example converts the values in a text field, containing "20," and a number field containing 10, into numbers so that they can be added using the @Sum function, which requires two numbers. The formula returns 30.