Converts text to a number in a locale-independent way.
Söz dizimi
NUMBERVALUE(text, [decimal_separator], [group_separator])Bağımsız değişkenler
textzorunlu
The text string to convert to a number.
decimal_separatoristeğe bağlı
The character used to separate the integer and fractional parts.
group_separatoristeğe bağlı
The character used to separate groups of numbers, such as thousands.
The NUMBERVALUE function converts text to a number by allowing you to specify custom decimal and group separators. This is particularly useful when importing data from different regions where number formatting conventions vary.
=NUMBERVALUE("1.234,56", ",", ".")→1234.56Converts a European-formatted number string using a comma as a decimal separator into a standard numeric value.
Select the cell
Click on the cell where you want to display the converted number.
Enter the formula
Type =NUMBERVALUE( followed by the text string and your specific separators, then close the parenthesis.
NUMBERVALUE is locale-independent and allows you to define custom separators, whereas VALUE relies on the system's regional settings.