Summary
The Excel VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value. Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
Purpose
Convert text to a number
Return value
A numeric value.
Syntax
=VALUE (text)
Arguments
- text – Tthe text value to convert to a number.
Usage notes
- Use the VALUE function to convert text to a numeric value.
- The VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value.
- Normally, Excel automatically converts text to numeric values as needed, so the VALUE function is not needed.
- Microsoft states that the VALUE function is provided for compatibility with other spreadsheet programs.
