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.