FORMULA LANGUAGE


@TextToNumber
Example

Converts a text string to a number, where possible.

Syntax

@TextToNumber( string )

Parameters

string


Return value

number


Usage

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

This function is useful for converting a number in a text field to a number that can be used for computation in a number field.

You can't use @TextToNumber to convert special text (such as that returned by @DocChildren or @DocDescendants) to a number.

@TextToNumber returns an error If you try to pass anything besides a string into it.

Language cross-reference

Val function of LotusScript language

Str function of LotusScript language

CInt function of LotusScript language

CLng function of LotusScript language

CSng function of LotusScript language

CDbl function of LotusScript language

Example
See Also