How do I ignore the "Number stored as text" error message permane.

R

reston33

I have numbers stored as text. I don't consider this to be an error, but
Microsoft Excel does, and puts a little green triangle in the upper left
corner of the cell. I can click to ignore the error, thereby hiding or
removing the green triangle, but after I save the document (type xml) and
retrieve it, the error returns. How do I permanently disable the green
triangle from appearing.
 
J

John

tools>options>error checking tab>remove tick in the number stored as text box
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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

Stop error checking a cell that has been formatted to text 3
Number stored as text 3
ignore error 1
Number displayed as text difficulties 4
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Are Error-Checking rules (in Excel Options) workbook-specific? 7
Ignore blank checkbox-Data Validation 0
convert column from numbers to text 2

Top