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.
Version 
Usage notes 

The VALUE function is meant to convert a text value that represents a number into a numeric value. The text can be a date, a time, or any other number, so long as the format can be recognized by Excel. When the conversion is successful, the result is a numeric value with no number formatting. When the VALUE function is unable to convert a text value to a numeric result, the result is a #VALUE! error.

=VALUE("July 15, 2021") // returns 44392
=VALUE("$125.50") // returns 125.5
=VALUE("32.5%") // returns 0.325

In general, there is no need to use the VALUE function because Excel automatically converts text to numbers as needed. However, VALUE is provided for compatibility with other spreadsheet applications.

  • Use the VALUE function to convert text input 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.
  • The VALUE function is provided for compatibility with other spreadsheet programs.
  • The VALUE function returns #VALUE! when a conversion is unsuccessful.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.