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.