NUMBERVALUE function.Converts strings of numeric notation (decimal points and commas) from various linguistic regions to numerical values.

Japanese version.

Functions for converting strings of numbers expressed in different formats to numeric values.
For example, in the United States, Japan, and China, three-digit separators are separated by a comma, and the boundary between integers and decimals is separated by a period. (period) for the boundary between integer and minority, but this is not the case in all countries (linguistic regions).
In some languages, the delimiter is a period and the boundary is a comma, while in others, it is some other character.
This function is designed to convert such strings to numbers in a locale-independent manner.
If you do not need to be concerned about locale, it is better to use the VALUE function.

How it works

TextRequired fieldSpecifies a string to be converted to a numerical value.
Decimal_separatorDepends on Excel settings (locale).Specify the symbol that separates integers and decimals.
Group_separatorDepends on Excel settings (locale).Specify the three-digit separator.


All results are numerical.

Example of numerical notation

The following is a partial list of examples used.

USA, China, Japan, etc., (comma). (period)
Germany, Italy, the Netherlands, etc.. (period), (comma)
Switzerland.' (apostrophe). (period)
Scandinavia, Russia, etc.Half-width space, (comma)


If the argument is a range of cells, it will be a Spill.

You enter a formula in only one cell, but the
It is automatically expanded to the other cells.



Microsoft Excel Functions Text