The VALUE function converts combinations of text and numbers in to a value. Excel can recognize constant, date or time formats and convert these text strings to a numerical value. If the text string is not in a recognizable format such as "three" or " 6 apples" excel will show a "#VALUE!" error value.

• The syntax for the function is VALUE(text) where "text" is a string of text that is to be converted to a numerical value.
  
  

Text can be converted directly bt enclosing text in quitation marks e.g VALUE("$60") = 60.

The VALUE function is not commonly used in excel as excel automatically converts text to numbers. The main use for this function is for preparing Excel spreadsheets so that they are compatible with other spreadsheet programs.