Using the Excel VALUE Function

Summary
The Excel VALUE function will convert a number represented by a text string into a number.Syntax
=VALUE (text)Syntax Breakdown
TextRequired. Text, enclosed in quotation marks (" ") or a reference to a cell containing text that you want converted to a number.
Usage Notes
VALUE 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.