Excel like a finance pro.
← The libraryPractice · 2 questions →
Text function
NUMBERVALUE
Converts text to a number using separators you specify, for other locales.
Rarely usedDifficulty 1200 · ProficientUsage rank #135 of 520
When to use it
VALUE with explicit decimal and group separators, for text formatted in another locale. Also understands percent signs.
The shape of it
- Syntax
=NUMBERVALUE(text, [decimal_separator], [group_separator])
Worked examples
European format
=NUMBERVALUE("1.234,56",",",".") → 1234.56
European format: comma decimal, dot thousands.
Percent text
=NUMBERVALUE("12%") → 0.12
Percent signs divide by 100.
Space groups
=NUMBERVALUE("1 234,5",","," ") → 1234.5
A space as the group separator.
Worth knowing
- Use it in a helper column when importing from European or Swiss systems.
- Leading and trailing spaces are ignored.
- Only the first character of each separator argument is used.
Where it goes wrong
- #VALUE! when the separators are the same or the text has characters other than digits and separators.
- Multiple percent signs each divide by 100.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.