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%)