When entering numbers as text
 

I have several spreadsheets that have numbers entered as text. When I change
it to text it gives me a green tag which I have to select and then choose
"Ignore error" to get it to disappear. Is there away to prevent that from
occurring? It is a real nuisance to do that everytime I add numbers as text.

Hi!

Goto ToolsOptionsError Checking

If you want to avoid all of those "lovely triangles", under Rules, uncheck
everything.

Biff

"jmcme" wrote in message
...
I have several spreadsheets that have numbers entered as text. When I
change
it to text it gives me a green tag which I have to select and then choose
"Ignore error" to get it to disappear. Is there away to prevent that from
occurring? It is a real nuisance to do that everytime I add numbers as
text.