Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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). dasher wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I move the comment box to the left of the cell? | Excel Worksheet Functions | |||
selected cell - top left | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
Timestamp cell to left after update | Excel Discussion (Misc queries) |