# Excel NUMBERVALUE function

## Summary

The Excel NUMBERVALUE function converts text that appears in a recognized format (like numbers, dates, or times) into a numeric value. It’s particularly useful for converting text to a number in a locale-independent way.
##### Syntax
```				```
=NUMBERVALUE(text, [decimal_separator], [group_separator])
```
```
• text: The text string that you want to convert into a number
• decimal_separator: [Optional] The character used for the decimal separator
• group_separator: [Optional] The character used to separate groups of numbers
##### Return value
A numeric value derived from the text string.

## How to use

NUMBERVALUE is used to convert text strings that represent numbers into actual numeric values. This function is especially useful when dealing with numeric data imported from different locales where the format of numbers (like decimal and thousands separators) might differ from the standard format of your Excel environment.

## Examples

##### Simple NUMBERVALUE
Converting Text to a Number: To convert a basic numeric text to a number:
```				```
=NUMBERVALUE("1234.56")
```
```
This converts the text “1234.56” to the numeric value 1234.56.
##### NUMBERVALUE with Decimal Separator
Handling Different Decimal Separators: Converting text with a specific decimal separator:
```				```
=NUMBERVALUE("1234,56", ",")
```
```
Converts the text “1234,56” (where the comma is used as a decimal separator) to 1234.56.
##### NUMBERVALUE with Group Separator
Converting Text with Group Separators: Converting a number in text format with a group separator:
```				```
=NUMBERVALUE("1,234.56", ".", ",")
```
```
This converts “1,234.56” to the numeric value 1234.56.
##### NUMBERVALUE in Data Import
Normalizing Imported Data: Converting numbers from a text file with unusual formatting:
```				```
=NUMBERVALUE(A2, ".", " ")
```
```
If A2 contains “1 234.56”, the formula converts it to 1234.56.
##### NUMBERVALUE for Locale-Specific Formats
Adapting to Different Locale Number Formats: Converting numbers in text format from a different locale:
```				```
=NUMBERVALUE("1.234,56", ",", ".")
```
```
This converts the European-formatted number “1.234,56” to 1234.56.