Documentation/Calc Functions/NUMBERVALUE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

NUMBERVALUE

Category:

Text

Summary:

Convert text to number, in a locale-independent way.

Syntax:

NUMBERVALUE("Text";decimal_separator;group_separator)

Returns:

Arguments:

Text is a valid number expression and must be entered with quotation marks.

decimal_separator (optional) defines the character used as the decimal separator.

group_separator (optional) defines the character(s) used as the group separator.

Additional details:

Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator

Examples:

=NUMBERVALUE("123.456";".";",") yields 123.456

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: