The Excel NUMBERVALUE function converts a number in text format to numeric value, using specified decimal and group separators. This function can be used to convert locale-specific values into locale-independent values.

**Syntax**: =NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])

The NUMBERVALUE function syntax has the following arguments:

**Text**(Required): The text to convert to a number.**Decimal_separator**(Optional): The character used to separate the integer and fractional part of the result.**Group_separator**(Optional): The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands.

**Example**: Let’s look at some Excel NUMBERVALUE function examples and explore how to use the NUMBERVALUE function as a worksheet function in Microsoft Excel:

**Syntax**: =NUMBERVALUE(A2,B2,C2)

**Result**:

Based on the Excel spreadsheet above, the following NUMBERVALUE examples would return:

**Syntax**: =NUMBERVALUE(A3,B3,C3)

**Result**: 3000.253

**Syntax**: =NUMBERVALUE(A4,B4,C4)

**Result**: 5260000

**Syntax**: =NUMBERVALUE(A5,B5,C5)

**Result**: 35286

**Syntax**: =NUMBERVALUE(A6,B6,C6)

**Result**: 0.2685

**Syntax**: =NUMBERVALUE(A7,B7,C7)

**Result**: 0.01

**Syntax**: =NUMBERVALUE(A8,B8,C8)

**Result**: 0.0008

**Note**:

- If any arguments are not valid, #VALUE! will be returned
- If the group separator appears after the decimal separater in the text value, #VALUE! will be returned
- If multiple decimal separators appear in the text value, #VALUE! will be returned
- If multiple characters are provided in the separator fields, only the first character will be used in each field
- If an empty text value is provided, a value of 0 will be returned
- If separator values are not provided, the current locale values are used
- Spaces in the text value are ignored
- Percent signs appearing at the end of the text value will affect the result. For example: =NUMBERVALUE(“15%”) will return the same result as entering =15% into a cell.