Excel VALUE Function

Using the Excel VALUE Function

Excel VALUE Function

Summary

The Excel VALUE function will convert a number represented by a text string into a number.

Syntax

=VALUE (text)

Syntax Breakdown

Text
Required. Text, enclosed in quotation marks (" ") or a reference to a cell containing text that you want converted to a number.

Usage Notes

VALUE converts text that is entered in a recognized format, such as a number, date, or time, into a number value.

If text is not in a number, date, or time format the function will return the #VALUE! error.

Generally, you will not use the VALUE function. This is because Excel converts text to numbers automatically. The main reason the VALUE function exists is to provide compatibility with other spreadsheet programs.