Numbers stored as text in Excel cannot be summed, averaged, or sorted numerically. They appear left-aligned, often show a green triangle warning, and return incorrect results in SUM and other numeric formulas. Several quick methods fix this.

Method 1: Error Check Dropdown

Select the cells showing the green triangle warning in the top-left corner. Click the yellow warning diamond that appears to the left of the selection. Choose Convert to Number from the dropdown. Excel converts all selected text numbers to real numbers in one step — this is the fastest method when the warning icon is visible.

Method 2: VALUE Function

=VALUE(A2)

VALUE converts a text string representing a number into an actual numeric value. Use this in a helper column next to your data. Once the formula column is complete, copy it and paste as Values Only into the original column, then delete the helper column.

Method 3: Multiply by 1

=A2*1

Multiplying a text number by 1 forces Excel to evaluate it as a number. Simple and reliable for straightforward cases without currency symbols or special characters.

Method 4: Text to Columns

Select the column of text numbers. Go to Data, then Text to Columns. Click Finish immediately without changing any settings. Excel re-parses the column values and automatically converts text numbers to actual numbers.

Method 5: Paste Special — Multiply

Type 1 in an empty cell and copy it. Select your text numbers. Go to Paste Special (Ctrl+Alt+V), choose Multiply under Operation, and click OK. Excel multiplies each cell by 1, converting text to numbers in place without a helper column.

Frequently Asked Questions

Why are my imported numbers stored as text in Excel?

This typically happens when importing CSV files where numbers have leading zeros (product codes, postal codes), currency symbols ($, EUR), thousand separators (commas), or are preceded by an apostrophe that forces text storage. Use VALUE or Text to Columns to convert them for calculations.

How do I prevent numbers from being stored as text in Excel imports?

When importing via Data, Get Data, From Text/CSV, set the column data type to Number explicitly in Power Query before loading. This prevents Excel from guessing the type and misidentifying numeric columns as text.