VALUE Function in Excel – Convert text to numeric value in Excel

VALUE Function in Excel converts Text into numeric value or number.

Syntax of VALUE Function in Excel:

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.