Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
tools/options and on the error checking tab uncheck number stored as text
-- Gary "prahz" wrote in message oups.com... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
then use Charles's suggestion
-- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
Huh?
Who is Charles and what was his suggestion? Gary Keramidas wrote: then use Charles's suggestion -- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
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" wrote: 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 prahz wrote: Huh? Who is Charles and what was his suggestion? Gary Keramidas wrote: then use Charles's suggestion -- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
Range("A1").Errors(xlNumberAsText).Ignore = True
NickHK "prahz" wrote in message oups.com... 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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
Thank you that worked.
I put it in the Sub Auto_Open() Function of my workbook. Die_Another_Day wrote: 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" wrote: 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 prahz wrote: Huh? Who is Charles and what was his suggestion? Gary Keramidas wrote: then use Charles's suggestion -- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
Thank you that worked.
I put it in Sub Auto_Open() and it turned it off on startup Die_Another_Day wrote: 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" wrote: 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 prahz wrote: Huh? Who is Charles and what was his suggestion? Gary Keramidas wrote: then use Charles's suggestion -- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number stored as text error message
This is Application code and will affect all workbooks.
Why don't you just go into ToolsOptionsError Checking and uncheck it there? On 14 Dec 2006 15:42:32 -0800, "prahz" wrote: Thank you that worked. I put it in the Sub Auto_Open() Function of my workbook. Die_Another_Day wrote: 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" wrote: 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 prahz wrote: Huh? Who is Charles and what was his suggestion? Gary Keramidas wrote: then use Charles's suggestion -- Gary "prahz" wrote in message ups.com... 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 wrote: tools/options and on the error checking tab uncheck number stored as text -- Gary "prahz" wrote in message oups.com... 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? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number stored as text | Excel Worksheet Functions | |||
How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
Number Stored as text Error | Excel Worksheet Functions | |||
Help 'Number Stored as Text Error' !!! | Excel Programming | |||
Number stored as text | Excel Discussion (Misc queries) |