Syntax of NUMBERVALUE function

NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])

The NUMBERVALUE function syntax has the following arguments.

• Text: 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.

NUMBERVALUE formula explanation

• If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used.
• If multiple characters are used in the Decimal_separator or Group_separator arguments, only the first character is used.
• If an empty string (“”) is specified as the Text argument, the result is 0.
• Empty spaces in the Text argument are ignored, even in the middle of the argument. For example, ” 3 000 ” is returned as 3000.
• If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value.
• If the group separator occurs before the decimal separator in the Text argument , the group separator is ignored.
• If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value.
• If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value.
• If the Text argument ends in one or more percent signs (%), they are used in the calculation of the result. Multiple percent signs are additive if they are used in the Text argument just as they are if they are used in a formula. For example, =NUMBERVALUE(“9%%”) returns the same result (0.0009) as the formula =9%%.

Example of NUMBERVALUE function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.