In general, there is no need to use the VALUE function because Excel automatically converts text to numbers as needed. However, VALUE is provided for compatibility with other spreadsheet applications.
Use the VALUE function to convert text input to a numeric value. The VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value. Normally, Excel automatically converts text to numeric values as needed, so the VALUE function is not needed. The VALUE function is provided for compatibility with other spreadsheet programs. The VALUE function returns #VALUE! when a conversion is unsuccessful.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
