Search

 

Module: Editor

Version: 2.2.1 +

Type: Double

Category: Conversion

 

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.

Updated: 2014-10-01