[thelist] excel export formatting

[Anthony Baratta]

brian cummiskey wrote:

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

If you are sending as CSV, try wrapping the numbers in "quotes".

--
Anthony Baratta

"I used to think the brain was the most
  important part of my body, until I realized
  what was telling me that." - Emo Phillips