Green Triangles in Excel: What They Mean

A green triangle in Excel is a small warning flag in the top-left corner of a cell. It means Excel's error checking has noticed something that might be a mistake, most often a number stored as text. The cell still works, but the warning is worth a look, because the thing it flags can quietly break totals and lookups. This guide explains what each green triangle means and how to fix it or hide it.

What does the green triangle mean?#

The green triangle comes from background error checking, a feature that scans your sheet as you work. When a cell breaks one of its rules, Excel marks the cell with a green triangle. It doesn't change the cell or stop formulas from calculating.

To see why a cell is flagged:

1. Select the cell.
2. A yellow warning icon with an exclamation mark appears next to it.
3. Hover over the icon to read the reason, or click it to see the fix options.

The options usually include a fix (such as Convert to Number), Help on this Error, Ignore Error, Edit in Formula Bar and Error Checking Options.

Don't confuse it with other corner marks. A red triangle in the top-right corner means the cell has a note. In Microsoft 365, a purple mark means a threaded comment.

The most common reasons for a green triangle#

These are the rules you'll meet most often, and what to do about each one:

Number stored as text: the one to fix#

"The number in this cell is formatted as text or preceded by an apostrophe" is the most common green triangle, and the one that matters most. A number stored as text looks normal, but SUM, AVERAGE and COUNT skip it, and lookups don't match it.

Here, two quantities came in as text:

=SUM(B2:B6) returns 47 instead of 85, because it skips 8 and 30. To count how many cells are text, compare COUNTA (every filled cell) with COUNT (real numbers only):

=COUNTA(B2:B6)-COUNT(B2:B6)

The result is 2. To fix them, select B2:B6, click the warning icon and choose Convert to Number. The total updates to 85. If a whole column of numbers adds up to nothing, see why SUM is showing 0, and the full guide to numbers stored as text covers stubborn cases with spaces.

Text numbers usually arrive in one of three ways: data imported from a CSV file or another system, cells formatted as Text before the numbers were typed, or entries that start with an apostrophe ('). The apostrophe tells Excel "keep this as text" and doesn't show in the cell, only in the formula bar.

Sometimes text is what you want, for example product codes like 00123 where the leading zeros matter. In that case, choose Ignore Error.

Text dates with a two-digit year#

A date typed or imported as text with a two-digit year, such as '3/15/24, gets its own green triangle. Excel can't be sure whether 24 means 1924 or 2024, and as text the date won't sort or calculate correctly. Click the warning icon and choose Convert XX to 20XX (or 19XX) to turn it into a real date. The guide to dates that show as numbers explains how real dates are stored.

Inconsistent formula and omitted cells#

These two rules catch copy mistakes. Say D2:D6 all hold =B2*C2, =B3*C3 and so on, but someone typed a fixed number or =B4+C4 into D4. Excel flags D4 with "Inconsistent Formula", because it breaks the pattern of the cells around it. Usually that's a real error: copy the correct formula from the cell above.

"Formula Omits Adjacent Cells" appears when a range like =SUM(B2:B5) stops right before more numbers in B6. Often this means a new row was added below the range, so the total is missing it. Click the warning icon and choose Update Formula to Include Cells. If the gap is on purpose, choose Ignore Error.

Neither rule is a definite mistake. They are hints, so check the formula and decide. A real error, such as #VALUE!, also shows a triangle; the guide to the #VALUE! error explains how to fix it.

How to remove green triangles without changing the data#

To hide the triangle for some cells only, select them, click the warning icon and choose Ignore Error. Excel remembers this for those cells. The rule keeps working everywhere else, so new problems are still flagged.

You can select a whole range first and ignore them all at once, as long as the first cell you select shows the warning icon.

How to turn off error checking rules#

If one type of warning is always noise for your work, turn that rule off:

• Windows: File > Options > Formulas. Under Error checking rules, clear the box for the rule. To hide every green triangle, clear Enable background error checking.
• Mac: Excel > Preferences > Error Checking, then clear the rule or the main checkbox.

These settings apply to Excel on your computer, not just to one file. Turning off all checking is rarely a good idea, because the "Number Stored as Text" warning catches real problems. Other formula issues, such as a circular reference or formulas that stop updating, show up in different ways.

Practise it#

Practise debugging a SUM in a live spreadsheet: you'll find the text numbers and broken ranges that green triangles warn about, and fix the total yourself. Then practise converting text to numbers with VALUE. Start with the exercise on this page.