Stop error checking a cell that has been formatted to text

T

Tammy

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!
 
T

Tammy

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

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

Similar Threads

What is small green triangle in upper left corner of cell? 6
How do I ignore the "Number stored as text" error message permane. 3
Number stored as text 3
Are Error-Checking rules (in Excel Options) workbook-specific? 7
what is the geen triangle in a cells with number? 4
Auto Enter a Number into a Cell 6
convert column from numbers to text 2
tabsheet-function to get the formatted text of a cell 1

Top