ASP export to Excel formatting?

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.

Re: ASP export to Excel formatting?

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" wrote in message
news:%23HTDkQe5HHA.5844@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.
>

Re: ASP export to Excel formatting?

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 ^_^" wrote in message
news:%23ZXA3Ej5HHA.4436@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" wrote in message
> news:%23HTDkQe5HHA.5844@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.
>>
>
>