View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default probably an easy question

I uncheck the one that says "Enable background error-checking"


Gord

On Thu, 07 Feb 2008 09:56:14 -0600, Dave Peterson
wrote:

Tools|Options|error checking tab.
Uncheck the ones you hate <vbg

Jason wrote:

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?