removing green triangle in cell
 

Could someone please remind me how to turn off the little green triangle that
appears in the top left corner of cell? Thanks.
--
Shooter

Answer: removing green triangle in cell
 

Hi Shooter,

The green triangle in the top left corner of a cell is an indicator that Excel has detected a potential error or inconsistency in the formula or data in that cell. However, if you are sure that the data or formula in the cell is correct and you want to remove the green triangle, you can do so by following these steps:

1. Select the cell(s) with the green triangle.
2. Click on the "File" tab in the top left corner of the Excel window.
3. Click on "Options" in the left-hand menu.
4. In the Excel Options window, click on "Formulas" in the left-hand menu.
5. Scroll down to the "Error Checking" section.
6. Uncheck the box next to "Enable background error checking".
7. Click "OK" to save the changes.

This should remove the green triangles from the selected cells. However, keep in mind that disabling error checking can make it harder to spot actual errors in your data or formulas, so use this feature with caution.

toolsoptionserror checkingclear whatever error is causing the problem

"Shooter" wrote in message
...
Could someone please remind me how to turn off the little green triangle
that
appears in the top left corner of cell? Thanks.
--
Shooter

Better yet........disable the bloody things!!

Uncheck "enable error checking"

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 11:27:55 -0500, "CarlosAntenna" wrote:

toolsoptionserror checkingclear whatever error is causing the problem

"Shooter" wrote in message
...
Could someone please remind me how to turn off the little green triangle
that
appears in the top left corner of cell? Thanks.
--
Shooter

Actually, I like them. They let me know when something that appears to be a
number is really text.

Carlos

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Better yet........disable the bloody things!!

Uncheck "enable error checking"

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 11:27:55 -0500, "CarlosAntenna"
wrote:

toolsoptionserror checkingclear whatever error is causing the problem

"Shooter" wrote in message
...
Could someone please remind me how to turn off the little green triangle
that
appears in the top left corner of cell? Thanks.
--
Shooter