VALUE

Convert text to a number

Sponsored Link

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

Notes:

  1. Microsoft states that the VALUE function is provided for compatibility with other spreadsheet programs.

Sponsored Link

0 votes. 0 / 5