probably an easy question
 

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?

probably an easy question
 

Tools Options Error Checking clear the number stored as text checkox.
--
Gary''s Student - gsnu200767


"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?

probably an easy question
 

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?

--

Dave Peterson

probably an easy question
 

Perfect--thanks much to both of you!

"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?

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?