ASP export to Excel formatting?

Z

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.
 
R

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.
 
Z

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top