This Excel tutorial explains 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 VALUE function in Microsoft Excel is:
VALUE( text )
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 Excel spreadsheet above, the following VALUE examples would return:
=VALUE(A1) Result: 12345 =VALUE(A2) Result: 768.8 =VALUE(A3) Result: #VALUE! =VALUE("67") Result: 67
(scroll to see more)