VALUE

Convert text to a number

VALUE

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.
 

0 votes. 0 / 5