[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Number stored as text error message

prahz

12/13/2006 8:17:00 PM

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 Answers

Gary Keramidas

12/13/2006 8:20:00 PM

0

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

--


Gary


"prahz" <pthomlison@gmail.com> wrote in message
news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
>


Charles Chickering

12/13/2006 8:25:00 PM

0

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

prahz

12/13/2006 8:53:00 PM

0

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" <pthomlison@gmail.com> wrote in message
> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
> >

Gary Keramidas

12/13/2006 8:56:00 PM

0

then use Charles's suggestion

--


Gary


"prahz" <pthomlison@gmail.com> wrote in message
news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
>> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
>> >
>


prahz

12/13/2006 9:57:00 PM

0

Huh?

Who is Charles and what was his suggestion?


Gary Keramidas wrote:
> then use Charles's suggestion
>
> --
>
>
> Gary
>
>
> "prahz" <pthomlison@gmail.com> wrote in message
> news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
> >> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
> >> >
> >

Die_Another_Day

12/13/2006 10:47:00 PM

0

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" <pthomlison@gmail.com> wrote in message
> > news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
> > >> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
> > >> >
> > >

NickHK

12/14/2006 3:03:00 AM

0

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

NickHK

"prahz" <pthomlison@gmail.com> wrote in message
news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
>

prahz

12/14/2006 11:43:00 PM

0

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" <pthomlison@gmail.com> wrote in message
> > > news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
> > > >> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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?
> > > >> >
> > > >

prahz

12/14/2006 11:43:00 PM

0

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" <pthomlison@gmail.com> wrote in message
> > > news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
> > > >> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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

12/15/2006 12:27:00 AM

0

This is Application code and will affect all workbooks.

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




On 14 Dec 2006 15:42:32 -0800, "prahz" <pthomlison@gmail.com> 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" <pthomlison@gmail.com> wrote in message
>> > > news:1166043165.489763.274030@73g2000cwn.googlegroups.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" <pthomlison@gmail.com> wrote in message
>> > > >> news:1166041006.890411.292040@n67g2000cwd.googlegroups.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