ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I Delete Symbol in Cell That Has A Formula? (https://www.excelbanter.com/excel-discussion-misc-queries/26873-can-i-delete-symbol-cell-has-formula.html)

John

Can I Delete Symbol in Cell That Has A Formula?
 
I am using Excel 2004 for Mac and can't fiigur out how to get rid of the
little green triangle in the upper left hand corner of a cell that contains a
formula. Is there a way to accomplish this?

Peo Sjoblom

I am not using my Mac at the moment but a guess would be

excelpreferenceserror checking and uncheck enambe background error
checking or something similar

on a pc it's under toolsoptionserror checking

Regards,

Peo Sjoblom

"John" wrote:

I am using Excel 2004 for Mac and can't fiigur out how to get rid of the
little green triangle in the upper left hand corner of a cell that contains a
formula. Is there a way to accomplish this?


Dave Peterson

I don't speak the Mac, but in WinTel versions:

Tools|options|Error checking tab|
Uncheck the rules you don't want (inconsistent formulas???)

John wrote:

I am using Excel 2004 for Mac and can't fiigur out how to get rid of the
little green triangle in the upper left hand corner of a cell that contains a
formula. Is there a way to accomplish this?


--

Dave Peterson


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com