how do you supress the "Number stored as text" error message

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

Is there a way to supress the feature that displays a green triangle in the
upper left corner of a cell when you store numbers as text? I frequently
WANT to store numbers as text, and I'd like to make those triangles
disappear.

Thanks in advance,

Paul
 
Paul

Tools>Options>Error Checking. Uncheck "Enable background error checking".

Gord Dibben Excel MVP
 

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

How do I ignore the "Number stored as text" error message permane. 3
What is small green triangle in upper left corner of cell? 6
Non matching text data of the same values 3
getting rid of the "Comment Stored as Text" indicator 2
How do I eliminate the green triangle throughout my spreadsheet? 2
Stop error checking a cell that has been formatted to text 3
Number stored as text 1
formating numbers to text in columns 1

Back
Top