Number stored as text error message

[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?

 

[Gary Keramidas]

tools/options and on the error checking tab uncheck number stored as text

 

[prahz]

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?

 

[Gary Keramidas]

then use Charles's suggestion

--


Gary

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?

 

[prahz]

Huh?

Who is Charles and what was his suggestion?

 

[Die_Another_Day]

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

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?

Charles

 

[NickHK]

Range("A1").Errors(xlNumberAsText).Ignore = True

NickHK

 

[prahz]

Thank you that worked.

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

 

[prahz]

Thank you that worked.

I put it in Sub Auto_Open() and it turned it off on startup

 

[Gord Dibben]

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.

Gord Dibben MS Excel MVP