eliminate exclamation point in yellow diamond

  • Thread starter Thread starter Larry Smith
  • Start date Start date
L

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
 
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.
 
Larry,
Go to Tools -->Options - Edit Tab. Deselect "Show Insert Options Box"

HTH's

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

HTH's

Bobbie
Click to expand...

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
 
Or better yet........<g>

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


Gord Dibben MS Excel MVP
 
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.
Click to expand...


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
 
Or better yet........<g>

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


Gord Dibben MS Excel MVP
Click to expand...

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
 
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.
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top