Why CSV Numbers Show as Text in Excel — and How to Fix It

You open a CSV in Excel, try to run a SUM formula on a column of prices, and get 0. Or you sort a column numerically and it sorts 1, 10, 100, 2, 20 instead of 1, 2, 10, 20, 100. The problem: those numbers are stored as text, not numeric values.

Here is why this happens and the fastest ways to fix it.

Why Numbers End Up Stored as Text in Excel

When Excel opens a CSV by double-clicking, it applies its own rules for column type detection. If anything about a value looks ambiguous — a leading space, inconsistent formatting, mixed numeric and text rows in the same column — Excel defaults to storing the whole column as text.

Common causes:

• Currency symbols or formatting. Values like "$1,234.00" or "€500" are text strings, not numbers. Excel reads the symbol and treats the whole cell as text.
• Commas inside numbers. "1,234" — Excel may read the comma as part of the value rather than a thousands separator, depending on locale settings.
• Leading spaces. A space before a number (" 42" instead of "42") makes Excel treat it as text. These are invisible and common in poorly-formatted exports.
• Mixed column content. If a column has mostly numbers but a few cells contain "N/A" or "—", Excel may treat the whole column as text.
• The CSV importer simply not detecting types. Basic CSV open (double-click) in Excel does minimal type inference. The Text Import Wizard and proper converters do better.

How to Spot Text-Stored Numbers in Excel

Two quick visual signals:

Alignment. Real numbers are right-aligned in Excel cells by default. Text is left-aligned. If your numeric column is left-aligned, those are text values.

Green triangle warning. Excel often flags text-stored numbers with a small green triangle in the top-left corner of the cell. Click a cell with the triangle and a warning icon appears — it says "Number Stored as Text." This is the clearest confirmation.

Formula test. Type =SUM(A1:A10) on a column. If the result is 0 despite visible numbers in the cells, the values are stored as text. A real numeric column returns the correct sum.

Sell Custom Apparel — We Handle Printing & Free Shipping

Fix 1: Re-Convert the CSV Using a Proper Converter

The cleanest fix is to avoid the problem entirely. Instead of double-clicking the CSV in Excel, use the free browser converter — it detects numeric columns properly and stores them as actual numbers in the .xlsx output.

Upload the original CSV to the browser tool, download the .xlsx, open it in Excel. Numeric columns will be right-aligned, SUM and AVERAGE formulas will work immediately, and sorting will be numerical — no cleanup required.

This is the preferred approach when you have the original CSV file and want to start fresh rather than fix a bad import.

Fix 2: Convert Text to Numbers Directly in Excel

If you only have the already-opened Excel file and cannot re-convert, here are the fastest in-Excel fixes:

Method A — Paste Special multiply by 1:

1. Type the number 1 in any empty cell
2. Copy that cell (Ctrl+C)
3. Select your text-number column
4. Right-click > Paste Special > Multiply > OK

Multiplying by 1 converts text representations of numbers to actual numeric values.

Method B — Text to Columns:

1. Select the column with text numbers
2. Data > Text to Columns
3. Click Finish immediately (no changes needed)

This forces Excel to re-parse the column and usually converts text numbers to numeric in the process.

Method C — Error button: If you see green triangles, select the affected cells, click the warning icon that appears, and choose "Convert to Number."

Frequently Asked Questions

Why does =SUM() return 0 on numbers in my CSV?

The values are stored as text, not numbers. SUM ignores text values. Use one of the fixes above — re-convert the CSV using the browser tool (cleanest) or use Paste Special multiply by 1 to fix in place.

Can I prevent this from happening in the first place?

Yes — use a converter that handles type detection rather than double-clicking the CSV. The browser CSV to Excel tool detects numeric columns and stores them correctly. Using Excel's Data > From Text/CSV import wizard (instead of double-click) also gives you control over column types before importing.

My numbers have currency symbols like $ or €. How do I convert them?

First strip the currency symbol: select the column, Ctrl+H (Find and Replace), find "$" replace with nothing. Then the values will be plain numbers that Excel can store correctly. Alternatively, strip the symbols in your original data before exporting to CSV.

After converting text to numbers, some cells still show as text. Why?

Those cells likely have leading or trailing spaces, or contain non-numeric characters (em dashes, special minus signs, non-breaking spaces). Check cells that did not convert, select them, press F2 to enter edit mode and look for hidden characters at the start or end of the value.