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:

VALUE( text )

Where,

  • text – A text, that you want to be converted into numeric value or number.

 

Example of VALUE Function in Excel:

Formula

VALUE Function in Excel 1

  • 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

VALUE Function in Excel 2

Note: #VALUE! Error occurs if the supplied argument cannot be interpreted as a numeric value in excel.

previous-small VALUE Function in Excel                                                                                                                next_small VALUE Function in Excel