Beginner Text

VALUE

Converts text that looks like a number into an actual number Excel can calculate with.

Compatibility: All Excel versions

Syntax

Example

When to Use It

Use VALUE to fix numbers that were imported or pasted as text (often left-aligned instead of right-aligned), so they can be used in SUM, AVERAGE, and other calculations.