VALUE Function in Excel: Syntax, Examples and Free Practice
VALUE is an Excel Text function. Converts text that looks like a number into an actual number.
VALUE syntax
=VALUE(text)
Arguments
text: The text to work with
When to use VALUE
VALUE is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice VALUE online, free
Open the live Excel-style spreadsheet and try VALUE yourself. No Excel install or sign-up needed to start.
Practice VALUE now →More Text functions
Frequently asked questions
What does the VALUE function do in Excel?
Converts text that looks like a number into an actual number.
What is the syntax of VALUE in Excel?
The syntax is =VALUE(text). text: The text to work with.
Where can I practice VALUE online for free?
Open the free live spreadsheet on Cellgrids and try VALUE 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