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:

Excel NUMBERVALUE - How to use the Excel NUMBERVALUE function

Syntax:  =NUMBERVALUE(A2,B2,C2)

Result:

Excel NUMBERVALUE function - How to use the Excel NUMBERVALUE function

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.

Add a Comment

Your email address will not be published. Required fields are marked *