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

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.
--
Kevin

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

Tools/ Options/ Error checking...
Disable options to suit your preferences.
--
David Biddulph

"reston33" wrote in message
...
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.
--
Kevin

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

toolsoptionserror checking tabremove 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)


"reston33" wrote:

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.
--
Kevin