Disable error checking 1

[randy700]

In Excel 2003, is there a method to disable error checking? I'm talking about a situation where cells are formatted as text that display an error (identified by a little green tick in the upper left corner of the cell). I'd like to turn this off, so the error is not displayed.

Randy

 

[dhookom]

The little indicator allows you to drop down some options for error handling. There is a check box to turn off Number stored as Text.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Thanks, Duane, but that's not exactly what I'm asking.
I don't want the indicator to ever appear. I suspect
there's an option setting somewhere but haven't been
able to locate it.


Randy

 

[SkipVought]

Tools > Options - Error Checking tab

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

Skip,
What's the difference between my suggestion and your's? Or, is there a difference? The dialogs look mostly the same.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

He seemed to miss something.

No material difference.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[randy700]

I suspect there's an option setting somewhere but haven't been able to locate it.
Skip provided the location.



Randy