MS Excel: Value Function
In Excel, the Value function converts a text value that represents a number to a number.
The syntax for the Value function is:
Value( text )
text is the text value to convert to a number. If text is not a number, the Value function will return #VALUE!.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Value(A1) would return 12345 =Value(A2) would return 768.8 =Value(A3) would return #VALUE! =Value("67") would return 67