[thelist] excel export formatting
Anthony Baratta
Anthony at Baratta.com
Tue Aug 10 16:12:31 CDT 2004
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
More information about the thelist
mailing list