VALUE Function in Excel converts Text into numeric value or number.
Syntax of VALUE Function in Excel:
VALUE( text )
Where,
- text – A text, that you want to be converted into numeric value or number.
Example of VALUE Function in Excel:
Formula
- In the above examples different date and time formats, decimal values, currency formats and percentages are converted into numeric value.
So the result will be
Result
Note: #VALUE! Error occurs if the supplied argument cannot be interpreted as a numeric value in excel.