[thelist] excel export formatting

brian cummiskey brian at hondaswap.com
Tue Aug 10 15:47:20 CDT 2004


    Hey all, I have a pretty big asp application on my Intranet (IE only 
to code for here....)
I have set a header to export/open with excel, as its a big table, and 
many exec's will probably want to save it.

The problem im having is that excel by default makes long number cells 
scientific, resulting in 2312312321 E-10 or whatever the case may end up.

Is there a way to send a header or something to make it so all the excel 
cells are in "text" format?


More information about the thelist mailing list