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
 
Hi,

go to Menu, Options, error checking tab, uncheck
"number stored as text".

jeff
 
Paul

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

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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