NUMBERVALUE Function in Excel: Syntax, Examples and Free Practice
NUMBERVALUE is an Excel Text function. Converts text to a number in a locale-independent way.
NUMBERVALUE syntax
Arguments
text: The text to work withdecimal_separator: The character used for the decimal point (optional)group_separator: The character used to separate thousands (optional)
When to use NUMBERVALUE
NUMBERVALUE is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice NUMBERVALUE online, free
Open the live Excel-style spreadsheet and try NUMBERVALUE yourself. No Excel install or sign-up needed to start.
Practice NUMBERVALUE now →More Text functions
Frequently asked questions
What does the NUMBERVALUE function do in Excel?
Converts text to a number in a locale-independent way.
What is the syntax of NUMBERVALUE in Excel?
The syntax is =NUMBERVALUE(text, [decimal_separator], [group_separator]). text: The text to work with; decimal_separator: The character used for the decimal point (optional); group_separator: The character used to separate thousands (optional).
Where can I practice NUMBERVALUE online for free?
Open the free live spreadsheet on Cellgrids and try NUMBERVALUE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts