1 is a value

NUMERAL VALUE function

This article describes the formula syntax and usage of the NUMBER function in Microsoft Excel.

description

Converts text to numbers in a way that is locale independent.

syntax

NUMBER VALUE (text; [decimal separator]; [group separator])

The NUMBER function syntax has the following arguments:

  • text Required. The text to be converted to a number.

  • Decimal separator Optional. The character used to separate the whole number from the decimal places of the result.

  • Group separator Optional. The character used to separate groups of numbers, e.g. B. between thousands and hundreds or between millions and thousands.

Hints

  • If the arguments decimal separator and group separator are not specified, the separators for the current locale are used.

  • If multiple characters are specified in the decimal separator and group separator arguments, only the first character is used.

  • If an empty string ("") is specified as the argument Text, the result is 0.

  • Spaces in the text argument are ignored, even if they are 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 argument text, NUMBERVALUE returns the error value #VALUE! back.

  • If the group separator is present in front of the decimal separator in the argument text, the group separator is ignored.

  • If the group separator is present after the decimal separator in the argument text, NUMBER VALUE returns the #VALUE! back.

  • If one of the arguments is not valid, NUMBERVALUE returns the #VALUE! back.

  • If the argument text ends with one or more percent signs (%), these will be used in calculating the result. Several percent signs in the text argument are additive, as is the case when these signs are used in a formula. For example, = NUMBER VALUE ("9 %%") returns the same result (0.0009) as the formula = 9 %%.

example

Copy and paste the sample data in the following table into cell A1 of a new Excel worksheet. To see the results of the formulas, highlight them, press F2, and then press ENTER. If necessary, you can adjust the width of the columns so that all data is displayed.

formula

description

Result

= NUMBER VALUE ("2,500.27"; "."; ",")

Returns 2,500.27. The decimal separator of the text argument in the example is given as a point in the second argument and the group separator is given as a comma in the third argument.

2500,27

= NUMBER VALUE ("3.5%")

Returns 0.035. Because none of the optional arguments are given, the decimal and group separators of the current locale are used. The% symbol is not displayed although the percentage is calculated.

0,035

Top of page