How to Convert Text to Number in Excel

Numbers stored as text are one of the most common reasons Excel totals, lookups, and filters behave strangely. The cells may look numeric, but Excel treats them like labels instead of values.

This usually happens after copying from a bank export, CSV, accounting system, CRM, or web report.

Quick fix with the warning icon

If Excel shows a small warning triangle, select the affected cells, click the warning icon, and choose Convert to Number.

This is the fastest fix when Excel has already detected the issue.

Multiply by 1

If the warning icon does not appear, put 1 in an empty cell, copy it, select the text-number range, then choose Paste Special -> Multiply.

Excel multiplies each selected value by 1, which converts many text numbers into real numbers without changing the displayed amount.

Use this carefully in an expense tracker or small business budget because blank cells, labels, and mixed fields should not be converted blindly.

Use VALUE in a helper column

For a visible formula approach, use VALUE.

This converts a text number in A2 into a numeric value. After checking the results, copy the helper column and paste values over the original column if needed.

Remove hidden characters

Some imports include spaces, currency symbols, commas, nonbreaking spaces, or other hidden characters. Clean those first:

If commas are part of the issue, remove them too:

Only remove symbols that you have confirmed are formatting characters. Decimal and thousands separators vary by locale, and a blanket replacement can change the value.

Common symptoms

Excel stores only 15 digits of numeric precision. Keep credit card numbers and long identifiers as text; converting them to numbers can replace digits after the fifteenth with zeros. Preserve leading zeros with text or an appropriate display format when the value is a code rather than a quantity.

After using a helper formula, check totals and sample values, then copy the results and use Paste Special → Values only if the original column should be replaced.

Do this with AI

Imported numbers can look fine until the review meeting, when totals or pivots do not match.

"Find columns where numbers are stored as text, convert amount fields safely, and leave invoice IDs and account codes alone"

Griddy can inspect the sheet, separate true amounts from identifier fields, and fix the columns that should actually calculate.

Try the cleanup on an expense tracker copy and verify subtotals before replacing imported source values.

Sources

• Microsoft Support: Convert numbers stored as text to numbers
• Microsoft Support: Format numbers as text and preserve long codes