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

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
 
G

Gord Dibben

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
getting rid of the "Comment Stored as Text" indicator 2
How do I eliminate the green triangle throughout my spreadsheet? 2
What is small green triangle in upper left corner of cell? 6
Non matching text data of the same values 3
Formatting to text - apostrophe does not show 3
formatting cells with numbers as text 2
Number displayed as text difficulties 4

Top