Number stored as text error message

  • Thread starter Thread starter prahz
  • Start date Start date
P

prahz

I have created a macro in vba to input a "string of numbers" into a
cell.
-Some of the numbers in the string have leading zeros so I have
formatted the cell type as "text."
-Excel gives me this green tick mark at the top right corner of the
cell showing a Number Stored as Text error.
-How do I suppress the green tick mark from not ever coming up?

Does anybody know how to do this?
 
Sorry, I should have been more clear...

Is there any vba code I could use in my macro to suppress that green
tick mark no matter who is using the file?
 
then use Charles's suggestion

--


Gary


prahz said:
Sorry, I should have been more clear...

Is there any vba code I could use in my macro to suppress that green
tick mark no matter who is using the file?
Click to expand...
 
That would be me. For some dumb reason when I post from Microsoft's
newsgroups the post's don't always show up in Google groups. My
suggestion was this:
Here's a possibility:
Application.ErrorCheckingOptions.NumberAsText = False
--
Charles Chickering

"A good example is twice the value of good advice."


prahz said:
I have created a macro in vba to input a "string of numbers" into a
cell.
-Some of the numbers in the string have leading zeros so I have
formatted the cell type as "text."
-Excel gives me this green tick mark at the top right corner of the
cell showing a Number Stored as Text error.
-How do I suppress the green tick mark from not ever coming up?

Does anybody know how to do this?
Click to expand...


Charles
 
This is Application code and will affect all workbooks.

Why don't you just go into Tools>Options>Error Checking and uncheck it there?




Thank you that worked.

I put it in the Sub Auto_Open() Function of my workbook.
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top