Excel functions / Text
NUMBERVALUE function
Turns text into a number, whatever decimal and thousands marks it uses.
Syntax
=NUMBERVALUE(text, [decimal_separator], [group_separator])
Arguments
text: The text to convert.decimal_separator(optional): The decimal mark in the text (default ".").group_separator(optional): The thousands mark in the text (default ",").
When to use it
NUMBERVALUE turns text into a number when the text uses a different decimal point or thousands separator from your own settings: a European "1.234,56" read on an English computer, for example. You tell it which character is which.
Examples
A European amount
A B C 1 Amount 2 '1.234,56 1234.56 In C2:
=NUMBERVALUE(A2, ",", ".")→ 1234.56With spaces between the thousands
A B C 1 Amount 2 '12 500,75 12500.75 In C2:
=NUMBERVALUE(A2, ",", " ")→ 12500.75
Common mistakes
- The two characters swapped. The second argument is the decimal point and the third the thousands separator. Swapped, the result is #VALUE! or a number a thousand times off.
NUMBERVALUE in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: NUMBERVALUE
- Danish: TALVÆRDI
- Dutch: NUMERIEKE.WAARDE
- Finnish: NROARVO
- French: VALEURNOMBRE
- German: ZAHLENWERT
- Hungarian: SZÁMÉRTÉK
- Italian: NUMERO.VALORE
- Norwegian: TALLVERDI
- Polish: WARTOŚĆ.LICZBOWA
- Portuguese (Brazil): VALORNUMÉRICO
- Portuguese (Portugal): VALOR.NÚMERO
- Russian: ЧЗНАЧ
- Spanish: VALOR.NUMERO
- Swedish: TALVÄRDE
- Turkish: SAYIDEĞERİ
Try NUMBERVALUE in the playground
Related functions
- VALUE: Converts text that looks like a number into a number.
- TEXT: Formats a number as text using a format code.
- SUBSTITUTE: Replaces specific text with new text.