The TextToDecimal function is a built-in function that converts Text t to a Decimal value. The only allowed decimal separator is the ".".

If t is outside the boundaries of the Decimal values, the function will return the Decimal default value. To check if the conversion is possible you can use the TextToDecimalValidate function.

Input parameters

t: Text Type

Output parameters

Decimal Type

Examples

Usage

Result

TextToDecimal( "200" )

200

TextToDecimal( "-200" )

-200

TextToDecimal( "200.482" ) 200.482

TextToDecimal( "-200.482" )

-200.482

TextToDecimal( "0.99999999" )

0.99999999

TextToDecimal( "abc" )

0

See Also

TextToDecimalValidate Function | Available Conversion Functions to Decimal | Available Built-in Functions