Using the Excel VALUE Function
SummaryThe Excel VALUE function will convert a number represented by a text string into a number.
Required. Text, enclosed in quotation marks (" ") or a reference to a cell containing text that you want converted to a number.
Usage NotesVALUE converts text that is entered in a recognized format, such as a number, date, or time, into a number value.
If text is not in a number, date, or time format the function will return the #VALUE! error.
Generally, you will not use the VALUE function. This is because Excel converts text to numbers automatically. The main reason the VALUE function exists is to provide compatibility with other spreadsheet programs.