Microsoft bug in excel.Please suggest a work around !!

[only2gayathri]

Hi all,

I have a page(vb.net) which directs to a excel sheet.This excel sheet
retains all the values(mainly numbers) from the page and displays
it.The problem is that sometimes the number's remain in text format
when downloaded to excel and this kind of creates a flag(similar to
the one when we add comments in the excel)in some of the cells.This
problem occurs only sometimes.
Can anyone suggest anyway of overcoming these??Like using a number
formatter(or x:num)

Please suggest a work around for this.

Thanks,
Kushi

[rowe_newsgroups]

How are you outputting the data? Are you using Ado.net or using com
interop and "hijacking" the excel document. If the latter, look up the
NumberFormat method in the excel 11.0 object library. If you're using
ADO.Net than I can't think of a solution off hand.

Thanks,

Seth Rowe
On Jan 31, 7:24 am, [e-mail] wrote:

Hi all,

I have a page(vb.net) which directs to a excel sheet.This excel sheet
retains all the values(mainly numbers) from the page and displays
it.The problem is that sometimes the number's remain in text format
when downloaded to excel and this kind of creates a flag(similar to
the one when we add comments in the excel)in some of the cells.This
problem occurs only sometimes.
Can anyone suggest anyway of overcoming these??Like using a number
formatter(or x:num)

Please suggest a work around for this.

Thanks,
Kushi

[only2gayathri]

I am using ado.net.Its basically a web based application.Can anyone
please suggest me if there is any solution to the problem??

On Jan 31, 8:31 pm, "rowe_newsgroups" <[e-mail]:

How are you outputting the data? Are you using Ado.net or using com
interop and "hijacking" the excel document. If the latter, look up the
NumberFormat method in the excel 11.0 object library. If you're using
ADO.Net than I can't think of a solution off hand.

Thanks,

Seth Rowe

On Jan 31, 7:24 am, [e-mail] wrote:

Hi all,

I have a page(vb.net) which directs to a excel sheet.This excel sheet
retains all the values(mainly numbers) from the page and displays
it.The problem is that sometimes the number's remain in text format
when downloaded to excel and this kind of creates a flag(similar to
the one when we add comments in the excel)in some of the cells.This
problem occurs only sometimes.
Can anyone suggest anyway of overcoming these??Like using a number
formatter(or x:num)

Please suggest a work around for this.

Thanks,
Kushi- Hide quoted text -

- Show quoted text -