# NUMBERVALUE

The NUMBERVALUE function converts text to a number, correctly handling different decimal and thousands separators such as commas and periods.

## Syntax

```javascript
numbervalue(text, decimal_separator, group_separator)
```

## Arguments

text - Required. The text to be converted to number.

decimal\_separator - Optional. The character used to differentiate between the integer and the fractional part of a number.

group\_separator - Optional. The character used as a thousand separator.

## Example

```javascript
NUMBERVALUE("2.456,78", ",", ".")
```

Returns 2456.78.

In this example, the Interest column is a data input field with text data. We've used the NUMBERVALUE function to convert the Interest text field to a numeric field that aligns with the other measures in the report.<br>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fxtrwywo0YA8udGy8QCIT%2Fimage.png?alt=media&#x26;token=81a6ec57-c627-44f8-afa3-c0637d70e5fe" alt="How to use the NUMBERVALUE function to convert the Interest text field to a number"><figcaption><p>Using the NUMBERVALUE function to convert the Interest text field to a number</p></figcaption></figure>
