Learn how to use the Excel VALUE function with syntax and examples.
The Microsoft Excel VALUE function converts a text value that represents a number to a number.
The syntax for the Microsoft Excel 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!.
The VALUE function can be used in the following versions of Microsoft Excel:
The VALUE function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel VALUE function examples and explore how to use the VALUE function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel VALUE examples would return:
=VALUE(A1) Result: 12345 =VALUE(A2) Result: 768.8 =VALUE(A3) Result: #VALUE! =VALUE("67") Result: 67