When entering numbers as text

J

jmcme

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.
 
B

Biff

Hi!

Goto Tools>Options>Error Checking

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

Biff
 
Top