Exceljet

Quick, clean, and to the point

Excel VALUE Function

Excel VALUE function
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.