Functions (all)

TextToNumber

Function Name:

TextToNumber

Description:

Takes a text string and converts it to a numeric value. It will consider the end of the number to be reached when it encounters a non-digit. So, for example,

=TextToNumber("one") returns zero ('o' is not a digit).

=TextToNumber("132a7") returns 132 ('a' is not a digit)

It will correctly handle negative numbers.

Minimum FH Version:

4.0

No. of Parameters:

1

Return Type:

Number

Parameter 1:

String

Examples:

=TextToNumber(%INDI.REFN%)