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)
 
Top