# 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.