How are you sending your numbers to excel?

If your are using some standard method, then you may just have to fix them
after they get there

Dim rng as Range
set rng =Range(cells(1,1),cells(rows.count,1))
rng.Numberformat = "general"
Range("IV1").Value = 1
Range("IV1").copy
rng.pasteSpecial xlValues, xlMultiply
Columns(256).Delete
ActiveSheet.UsedRange

--
Regards,
Tom Ogilvy


<lovely_angel_for_you@yahoo.com> wrote in message
news:1142901148.767202.39170@i39g2000cwa.googlegroups.com...
> Hi,
>
> I am in a similar situation. However, I am sending the numbers from my
> VB application to Excel and instead of being stored as numbers they are
> getting stored as Text. And if we check the excel, it stay the number
> are stored as text and gives the sae rectangle to fix it.
>
> Any help on how we can store the number as numbers directly to excel
> rather than changing the fields in excel after they have been entered.
>
> Any idea will be appreciated.
>
> Thanks & Regards
> Lovely
>
>
>
>
> Tom Ogilvy wrote:
> > numbers stored as text is a warning, not a data type.
> >
> > if the cells contain numbers and they are stored as text, then in later
> > versions of excel, you can get this indication. The only alternative
is to
> > store them as numbers, but it sounds like you want them stored as text
and
> > they are.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
>