What does the green tag in the top left of a cell mean?

G

Guest

I am preparing a table with values and percentages but in some areas (where
I'm doing a % calculation) a small green tag appears in the top left of the
cell with an exclamation mark. It suggests an error but the calculation is
right. What does the green tag mean and how do I get rid of it?
 
D

Dave Peterson

xl2002 added some checks--things like numbers stored as text or inconsistent
formulas.

You can see all those things that excel will check under:
tools|Options|Error checking

If you click on that little exclamation point, you'll see what excel thinks may
be wrong. You can tell excel to to ignore this (or you can even tell excel to
stop bothering you completely).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top