Techsurvivors

Archives => 2009 => Topic started by: jb on November 05, 2009, 08:49:04 AM

Title: Mac Office 2004 Excel question
Post by: jb on November 05, 2009, 08:49:04 AM

In a cell, why is there a small triangle in the upper left corner of a cell sometimes and sometimes not?
And this with a similar cell content in several cells. See picture.

[attachment=1646:Picture_2.jpg]

jb

Title: Mac Office 2004 Excel question
Post by: sandbox on November 06, 2009, 07:08:00 PM

Apparently it is a preference.

QUOTE

One way:

Uncheck the "Unlocked cells containing formulas" checkbox in
Preferences/Error Checking.

Another:
Select the cell(s) with the green triangle. A smart button will appear
with a yellow diamond and an exclamation point. Click the button. Choose
"Ignore Error" from the dropdown.

http://www.officeformac.com/ProductForums/Excel/3735