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