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.

Excel VALUE Function

Download Workbook

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.