# How to use the Excel NUMBERVALUE function

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.
READ:  How to use the Excel FIXED function