NUMBERVALUE

The NUMBERVALUE function converts text into a numeric value by interpreting decimal and thousands separators, such as commas and periods. It is useful when working with numbers stored as text, especially when data formats vary across regions or sources.

Syntax

NUMBERVALUE(text, decimal_separator, group_separator)

Arguments

• text: The text to convert into a numeric value.
• decimal_separator (Optional): The character used to separate the integer and fractional parts of a number.
• group_separator (Optional): The character used as the thousands separator.

Return value

Returns the numeric value represented by the specified text.

Example

NUMBERVALUE(Interest_Text, ".", ",")

In this example, the Interest_Text column is a data input field containing numeric values stored as text. The NUMBERVALUE function is used to convert the Interest_Text values into numeric values that can be used along with other measures in the report.

Excel equivalent

NUMBERVALUE