Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excell 2003 SP2 - When I enter information into a cell, a green triangle
appears and I cannot find the correct "search phrase" to get an answer as to what that means. These are spread sheets that have been reformatted from another version of Excell. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The green triangle means there is an anomaly that Excel wants to bring to
your attention. It might be an error, it might not, but it is an aide (in some opinions). -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Humber" wrote in message ... Excell 2003 SP2 - When I enter information into a cell, a green triangle appears and I cannot find the correct "search phrase" to get an answer as to what that means. These are spread sheets that have been reformatted from another version of Excell. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Humber, that is Excel's error checking, to see the options or turn it off
:), tools, options, error checking -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Humber" wrote in message ... Excell 2003 SP2 - When I enter information into a cell, a green triangle appears and I cannot find the correct "search phrase" to get an answer as to what that means. These are spread sheets that have been reformatted from another version of Excell. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Those are smart tag indicators. If you click on a cell that has one an icon
will appear to the left/above/below/right, depending upon your current view, and you can click on this to see what Excel thinks the problem should be. It could be a number that is formatted as text, or a formula that doesn't conform to other formulas in a row or column. Click the drop down on this icon to see a list of choices, one of which is ignore this error. -- Kevin Backmann "Humber" wrote: Excell 2003 SP2 - When I enter information into a cell, a green triangle appears and I cannot find the correct "search phrase" to get an answer as to what that means. These are spread sheets that have been reformatted from another version of Excell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |