Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dasher
 
Posts: n/a
Default What does the green tag in the top left of a cell mean?

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I move the comment box to the left of the cell? Frederic Excel Worksheet Functions 0 May 25th 05 02:25 PM
selected cell - top left Ciara Excel Discussion (Misc queries) 1 May 25th 05 12:16 PM
Excel VB-Copy formula down until adjacent cell (left) is blank? Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM
Syntax for inferred cell references donesquire Excel Worksheet Functions 4 April 4th 05 09:29 PM
Timestamp cell to left after update Tahlmorrah Excel Discussion (Misc queries) 3 December 3rd 04 12:35 AM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"