Resources > Formula Help

How Do I Convert Text to Numbers in Excel?

Last Updated: June 2026

Quick Answer

Use VALUE, Paste Special, or Excel's error-checking menu to convert numbers stored as text into real numbers.

Use VALUE

=VALUE(A2)

Use Multiply by 1

=A2*1

Use Paste Special

1. Type 1 in a blank cell.
2. Copy that cell.
3. Select the text-number range.
4. Use Paste Special > Multiply.

Why This Matters

Numbers stored as text can break SUMIFS, XLOOKUP, PivotTables, charts, and reports.

Book Excel Help