"Number stored as Text" warning message

moserz

New Member
Joined
Jul 12, 2006
Messages
20
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?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try this:

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

tony0682

Board Regular
Joined
May 19, 2005
Messages
164
Goto Tools -> Options -> Error Checking -> Uncheck Number Stored as Text
 

Watch MrExcel Video

Forum statistics

Threads
1,112,799
Messages
5,542,574
Members
410,560
Latest member
1ndependent
Top