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

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

Guest

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)
 
Joined
May 28, 2009
Messages
1
Reaction score
0
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.
 

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

Top