Convert a text string without number format.
The Excel VALUE function convert valid numbers with various number formatting (number, date, currency etc.) into a code number. For example, “=VALUE(“31-12-2017”)” returns “43100”, a number code that is stored in excel at its backend.
text – The text to convert in value
The numerical value of the text.
- The VALUE function converts text that appears in an Excel’s valid format (i.e. a number, date, or time format) into a numeric value.
- Use the TEXT function to translate a number into a specific text format.
- It returns #VALUE! error in case the text contains non – numerical character or not in one of the recognized Excel formats.
- “You do not generally need to use the VALUE function in a formula because Excel automatically converts text to numbers as necessary. This function is provided for compatibility with other spreadsheet programs.” as stated by Support.Office.