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.