Hi i am using the

<%
   Response.ContentType = "application/vnd.ms-excel"
%>

to create a dynamic report that is produced from a database. The only problem that i have encountered is when i get to numbers or anything that will begin with 0 it does not disply the zero. is there anyway i can format the excel spreadsheet that has been created so that the zeros appear.

thanks if anyone can help.

check out http://www.greggriffiths.org/webdev/both/excel which covers several approaches to this issue.