Home » Excel-Built-In-Functions » Excel-Value-Function

The format of the VALUE function is

where the Text argument is a text value that can be translated into a number.

If the VALUE function is not able to convert the supplied text value into a number, it will return the #VALUE! error.

Examples

The following spreadsheet shows the VALUE function being used for four different examples. Note that, in the example spreadsheet, the values in cells A2 - A4 are all text values. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results :

It is seen, from the examples above, that the Excel VALUE function can interpret different formats of numbers. For example,

• in the example in cell B2, the function understands the text value "1.0E-07" to represent the scientific notation for the number 0.0000001
  
  
• in the example in cell B2, the function understands the text value "50,000" to represent the number 50000

However, in the example in cell B4, the VALUE function is not able to interpret the currency $ symbol as part of a number, so it produces the #VALUE! error message.