ASP export to Excel formatting?

[zz12]

Hello. I have negatives values showing as parenthesis when viewed on an asp
page but when exported to excel as follows:

Response.ContentType = "application/vnd.ms-excel"

...the negative values lose the parenthesis formatting and was wondering how
I can preserve these parenthesis when viewed in excel through internet
explorer through the above code?

Thanks in advance.

[Rob ^_^]

Hi zz12,

I think this is a client setting. It may be either a Windows System setting
or an Excel Format statement.
I think you will have to incluced the Excel format for negative numbers
otherwise it will default to the system settings of the client machine.

Regards.
"zz12" <ID***********@Nowhere.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

Hello. I have negatives values showing as parenthesis when viewed on an
asp page but when exported to excel as follows:

Response.ContentType = "application/vnd.ms-excel"

..the negative values lose the parenthesis formatting and was wondering
how I can preserve these parenthesis when viewed in excel through internet
explorer through the above code?

Thanks in advance.

[zz12]

Been looking around on this and seems like Excel loses much functionality
when viewed through IE. Will look into it further and see how it goes.
Thanks for your reply Bob. Much appreciated. Happy Friday...cheers :)

"Rob ^_^" <ie**********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Hi zz12,

I think this is a client setting. It may be either a Windows System
setting or an Excel Format statement.
I think you will have to incluced the Excel format for negative numbers
otherwise it will default to the system settings of the client machine.

Regards.
"zz12" <ID***********@Nowhere.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>Hello. I have negatives values showing as parenthesis when viewed on an
asp page but when exported to excel as follows:

Response.ContentType = "application/vnd.ms-excel"

..the negative values lose the parenthesis formatting and was wondering
how I can preserve these parenthesis when viewed in excel through
internet explorer through the above code?

Thanks in advance.