probably an easy question

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

in excel 2003, there is a little green dot in each field (kind of looks like
when you have a comment in a field but on the left side instead of right)

When you click on it, it says something like, "!this number is formatted as
text or has an " "

We have some sheets that need to be formatted as text, so that icon is in
every single field. Is there a way to turn that off?
 
Tools > Options > Error Checking > clear the number stored as text checkox.
 
Tools|Options|error checking tab.
Uncheck the ones you hate <vbg>
 
I uncheck the one that says "Enable background error-checking"


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top