Module: Editor
Version: 2.2.1 +
Description
The formula 'ConvertTextToNumber' converts a text string that represents a number to a number of type double. The difference between the formula 'ConvertTextToNumber' and formula 'Value' is that the formula 'ConvertTextToNumber' can also convert numbers with decimals.
Parameters
Text: this is the text you want to convert.
Decimal_separator: this is the character that is used as a decimal separator in the text string.
Thousand_separator: this is the character that is used as a thousand seperator in the text string.
Example
Description
In the following example the formula 'ConvertTextToNumber' is used to convert a text string to a number.
Values parameters
Text: 5,000,000
Decimal_separator: .
Thousand_separator: ,
Result
Output: 5000000
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.