By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,491 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,491 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jan 31 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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, only2gayat...@gmail.com 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

Jan 31 '07 #2

P: n/a
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" <rowe_em...@yahoo.comwrote:
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, only2gayat...@gmail.com 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 -

Feb 1 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.