[thelist] excel export formatting

[Peter Brunone (EasyListBox.com)]

	Well, one hack-ish way that you might try is to add a space
character to the content.  I don't know if it'll work, but it does the
job when you're working in Excel.

	Of course that messes things up if they want to treat the number
as a number, in which case you'll have to look into formatting (which
can probably be done with some bizarre tag attribute that Excel
understands these days)... Let us know how the first idea works out.

Cheers,

Peter

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of brian cummiskey

    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?
--