It converts a text that represents a number to that number.
The syntax of the function is the following:
VALUE(text)
text: The text you want to convert to a number.
The text can be in any of the constant number, date, or time formats recognized by Excel. If it is not then the function returns the #VALUE! error.
The function is provided for compatibility with other spreadsheet software.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the VALUE function:
In the cells B1:B6 set the values of the cell range A1:A6.
If their values cannot be represented by a number then set the value in the corresponding cell of the B column to 0.
You can use the conditional function IFERROR and the VALUE function.
Then