« previous next »
Pages: [1]   Go Down

Author Topic: Mac Office 2004 Excel question  (Read 1281 times)

Offline jb

  • TS Addict
  • *****
  • Posts: 694
    • View Profile
    • http://
Mac Office 2004 Excel question
« 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
Logged
iMac 21.5" Intel i3, OS 10.6.8, 4 GB RAM, 500 GB HFS+ Internal HD, SuperDrive, 4 part 1TB HFS+ Firewire400 External HD 1, 250 GB HFS+ Firewire400 External HD 2, Powered 7 port USB Hub, USB Printer/Scanner, USB Printer/Fax/Scanner, USB Multiple Card Reader, Cable Modem, 16 GB USB 2.0 Flash Drive.

Offline sandbox

  • TS Addict
  • *****
  • Posts: 7825
    • View Profile
    • http://
Mac Office 2004 Excel question
« Reply #1 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
Logged
Pages: [1]   Go Up
« previous next »