"Number stored as Text" warning message

[moserz]

I have formatted my cells so that they are all of the category of "text" as to avoid some errors from my code (I did it by selecting the cells, then Format -> Cells -> Number -> Text). But whenever a number is typed in a cell, a little green triangle appears in the upper left corner of the cell. The Warning message tells me that the number is stored as text. however, I don't want that message to keep popping up. I can ignore it once, I know, but is there a way to always ignore it?

 

[NBVC]

Try this:

Tools|Options and select the Error Checking tab. Uncheck the Number Stored as Text checkbox.

 

[tony0682]

Goto Tools -> Options -> Error Checking -> Uncheck Number Stored as Text

 

[moserz]

sweet. it worked. Thanks