Stop error checking a cell that has been formatted to text
 

Hi,

Does anyone know if there is a way, without turning off error checking
completely, to tell Excel not to error check a cell that has been formatted
as text?

I have a column that has been formatted as text, but whenever I type a
number in the cell, the green triangle appears in the corner of the cell, and
a smart tag appears allowing me to ignore the error.

I know i can just ignore the green triangle and continue on, and I know I
can choose the option to ignore the error to get rid of the triangle.

However, isn't there a way to just format the column as text and not have to
worry about the error notification showing up?

Thanks for any suggestions!

Stop error checking a cell that has been formatted to text
 

Using Excel 2003.

"Tammy" wrote:

Hi,

Does anyone know if there is a way, without turning off error checking
completely, to tell Excel not to error check a cell that has been formatted
as text?

I have a column that has been formatted as text, but whenever I type a
number in the cell, the green triangle appears in the corner of the cell, and
a smart tag appears allowing me to ignore the error.

I know i can just ignore the green triangle and continue on, and I know I
can choose the option to ignore the error to get rid of the triangle.

However, isn't there a way to just format the column as text and not have to
worry about the error notification showing up?

Thanks for any suggestions!

Stop error checking a cell that has been formatted to text
 

Tools/ Options/ Error Checking:
Deselect "Number stored as text".
--
David Biddulph

"Tammy" wrote in message
...
Hi,

Does anyone know if there is a way, without turning off error checking
completely, to tell Excel not to error check a cell that has been
formatted
as text?

I have a column that has been formatted as text, but whenever I type a
number in the cell, the green triangle appears in the corner of the cell,
and
a smart tag appears allowing me to ignore the error.

I know i can just ignore the green triangle and continue on, and I know I
can choose the option to ignore the error to get rid of the triangle.

However, isn't there a way to just format the column as text and not have
to
worry about the error notification showing up?

Thanks for any suggestions!

Stop error checking a cell that has been formatted to text
 

Well, thank you very much! What an obvious option - but, i just overlooked
it. Thanks so much, David!

"David Biddulph" wrote:

Tools/ Options/ Error Checking:
Deselect "Number stored as text".
--
David Biddulph

"Tammy" wrote in message
...
Hi,

Does anyone know if there is a way, without turning off error checking
completely, to tell Excel not to error check a cell that has been
formatted
as text?

I have a column that has been formatted as text, but whenever I type a
number in the cell, the green triangle appears in the corner of the cell,
and
a smart tag appears allowing me to ignore the error.

I know i can just ignore the green triangle and continue on, and I know I
can choose the option to ignore the error to get rid of the triangle.

However, isn't there a way to just format the column as text and not have
to
worry about the error notification showing up?

Thanks for any suggestions!