Thread: How do I ignore the "Number stored as text" error message permane.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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


Reply With QuoteReply With Quote