SpreadsheetWeb blog
Excel VALUE Function
In this guide, we’re going to show you how to use the VALUE function and go over some tips and error handling methods.
The VALUE function is a Text function that converts a text string in a recognized format (i.e., a number, date, or time format) into a numeric value. In this guide, we’re going to show you how to use the VALUE function and go over some tips and error-handling methods.
Supported versions
- All versions
VALUE Function Syntax
VALUE(text)
Arguments
| text | The text you want to convert. |
VALUE Function Example
If the text in the VALUE function is recognizable by Excel, the function returns the numeric value without any formatting. For example, =VALUE("$1,000") returns 1000.
Remarks
- Excel's VALUE function is helpful to convert parsed text values into numbers.
- If Excel cannot recognize the number format in the text, the function returns #VALUE! error.