Excel Says “Number Stored as Text” — The Green Triangle

Updated July 2026 · By the CSVUndo team · 5 min read

The quick answer: that little green triangle in the top-left corner of a cell is Excel telling you “the number in this cell is stored as text.” It appears constantly right after you import a CSV as text — which is exactly what keeps your ZIP codes and barcodes intact. So don’t rush to “fix” it. For prices and quantities you’ll actually do maths on, convert them to real numbers. For codes, IDs and phone numbers, leave the triangle exactly where it is — converting those re-breaks them. This guide shows you which is which, and how to do both.

What the green triangle actually means

The small green triangle in a cell’s top-left corner is Excel’s error indicator, and here it means one thing: the number you see is stored as text, not as a real number. The consequence is that Excel won’t include a text-stored number in SUM, AVERAGE or any other calculation — it treats "42" the way it treats the word “banana”. Click a flagged cell and a yellow warning icon appears, spelling out “Number Stored as Text.”

Here is the part most guides miss: this warning very often appears the moment you import a CSV as text — which is precisely what CSVUndo recommends to protect codes. Seeing the triangle usually means you did the right thing. It is a notification, not an emergency, and whether you act on it depends on what lives in the column.

Convert it, or leave it alone?

The single question that decides everything: will you ever do arithmetic on this column? If yes — prices, amounts, quantities you plan to total — convert it to a real number. If the column is an identifier you only ever read, match or export, leave it as text and ignore the triangle. Here is the rule at a glance:

The pattern is simple: quantities get converted, identifiers stay put. A ZIP code is a label that happens to be written with digits, so making Excel treat it as a number gains you nothing and costs you your leading zeros.

How to convert text to a real number

When a column genuinely holds quantities, converting takes three clicks. This method changes the underlying values, not just their appearance:

1. Select the cells that show the green triangle and the warning.
2. Click the yellow warning icon that appears beside the selection (keyboard shortcut: Alt + Shift + F10).
3. Choose “Convert to Number.” The triangles vanish and the values now count in SUM and AVERAGE.

Microsoft documents this and a few alternatives in its own help article on converting numbers stored as text to numbers. If you only need the figures to look right but not necessarily to recalculate, applying a number format is a lighter touch — see Microsoft’s note on fixing text-formatted numbers with a number format.

Convert a whole column at once

For a large range, the “multiply by 1” trick is faster than the warning menu. It forces every selected cell through a maths operation that turns text digits into real numbers:

1. Type 1 into any blank cell and press Enter.
2. Copy that cell (Ctrl + C).
3. Select the range you want to convert.
4. Right-click → Paste Special → tick Multiply → OK.

Every value is silently multiplied by one — unchanged in size, but now a genuine number. A third option is a helper column with =VALUE(A2); copy the result and paste it back as values. All three produce the same real numbers.

The codes you should never convert

This is the whole reason CSVUndo exists, so read it before you click anything. Do not convert ZIP codes, SKUs, UPC or EAN barcodes, phone numbers, or account and order IDs to numbers. Converting them re-triggers the exact damage this site is built to undo: leading zeros disappear (07030 → 7030), long barcodes flip into scientific notation (885909560622 → 8.85909E+11), and 16+ digit account numbers lose their final digits to Excel’s 15-significant-figure limit — a loss that is permanent and can only be undone by re-exporting from the source system.

The green triangle on a code column is not a problem to solve; it is proof the column is safe. If you want the mechanics of why those zeros vanish, see why leading zeros disappear from CSV files. The same one-way trap catches long identifiers in Excel’s scientific-notation guide, and date-shaped codes in when Excel turns numbers into dates. In every case the fix is the same: keep the column as text.

Turn the warning off without converting

If a sea of green triangles is just visual noise, you can switch the indicator off and keep every value as text. This changes nothing about your data — it only stops Excel flagging it:

1. Go to File → Options → Formulas.
2. Under Error checking rules, untick “Numbers formatted as text or preceded by an apostrophe.”
3. Click OK. The triangles disappear; your leading zeros and barcodes stay exactly as they are.

This is the right move for a workbook that is mostly codes: a clean-looking sheet without sacrificing a single digit — the opposite of what “Convert to Number” would do to the same cells.

Frequently asked questions

Sources: Microsoft’s guidance on converting numbers stored as text to numbers in Excel and on fixing text-formatted numbers by applying a number format. Excel’s 15-significant-digit ceiling is a property of IEEE 754 double-precision floating point.