Converts text to a number in a locale-independent way.
Sintaxe
NUMBERVALUE(text, [decimal_separator], [group_separator])Argumentos
textobrigatório
The text string to convert to a number.
decimal_separatoropcional
The character used to separate the integer and fractional parts.
group_separatoropcional
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.