eliminate exclamation point in yellow diamond

[Larry Smith]

Hi,

I'm using Excel 2002.
One of my worksheets uses a lot of numbers entered as text and the
little dark green tick mark shows in the corners of the cells.
When you go to one of those cells I see the exclamation point in a
yellow diamond. I imagine it's an error message related to using
numbers as text.

My question is whether there is a setting I can change so that that
does not constantly appear?

TIA


--
Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

 

[Alan]

I think its the accursed SmartTags which arrived in OfficeXP. I don't know
why MS do this sort of thing, it may be of use if you want it and ask for
it, but to an experienced user you don't really need to be informed that the
formula in a cell contains a different range to the one next to it, or in
your case that numbers are formatted as text, you already know!.
Look up Smart Tags in help and it advises how to turn them off.
Regards,
Alan.

 

[Bobbie]

Larry,
Go to Tools -->Options - Edit Tab. Deselect "Show Insert Options Box"

HTH's

Bobbie

 

[Larry Smith]

Larry,
Go to Tools -->Options - Edit Tab. Deselect "Show Insert Options Box"

HTH's

Bobbie

I'm afraid this did not get it done. Still clicking on any box that
has the green corner mark results in the exclamation point diamond
covering the cell to the left.

But thanks anyway.


--
Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

 

[Gord Dibben]

Or better yet........<g>

Tools>Options>Error Checking. Deselect "enable error checking.


Gord Dibben MS Excel MVP

 

[Larry Smith]

I think its the accursed SmartTags which arrived in OfficeXP. I don't know
why MS do this sort of thing, it may be of use if you want it and ask for
it, but to an experienced user you don't really need to be informed that the
formula in a cell contains a different range to the one next to it, or in
your case that numbers are formatted as text, you already know!.
Look up Smart Tags in help and it advises how to turn them off.
Regards,
Alan.

That's not the answer unfortunately since when went to that I found
that the Smart Tags were already set as being off.

Dontcha just love all this extra crap Microsoft tosses in?

Thanks anyway,


--
Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

 

[Larry Smith]

Or better yet........<g>

Tools>Options>Error Checking. Deselect "enable error checking.


Gord Dibben MS Excel MVP

BING BING BING - we have a winner.

Thank you Gord. That deselection solved my problem.

Much appreciated.


--
Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

 

[Gord Dibben]

Happy to help Larry

Thanks for the feedback.

I think Bobbie was on the right track but posted the wrong option.

Happens to all of us.

Gord

BING BING BING - we have a winner.

Thank you Gord. That deselection solved my problem.

Much appreciated.

Gord Dibben MS Excel MVP