Excel VALUE Function

Summary

The Excel VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value. Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.

Purpose

Convert text to a number

Return value

A numeric value.

Syntax

=VALUE (text)

Arguments

text - Tthe text value to convert to a number.

Usage notes

Use the VALUE function to convert text to a numeric value.
The VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value.
Normally, Excel automatically converts text to numeric values as needed, so the VALUE function is not needed.
Microsoft states that the VALUE function is provided for compatibility with other spreadsheet programs.