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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Hi,
I have excel files storing numeric data as text and most of the values have leading zeros. However, not only excel shows the "number stored as text error" message, but also automatically removes the leading zeros (converts the text to a number). How can I disable this functionality and preserve the leading zeros (this is a problem when pasting large portions of data from SQL query results into excel worksheet, because they get formatted immediately and the UNDO command cannot be used here).

I hope someone here knows how to get around this issue.
 
Back
Top