I create the download to excel for a table generated in ASP. But the data in excel is not converted appropriately to numeric. Even If I try within excel to convert to numeric it does not accept it. Help
The following is what I use:<BR><BR>Response.ContentType = "application/vnd.ms-excel"<BR><BR>The I use the <body> tags and <table> tags etc....<BR><BR>It works fine to generate the excel. But numbers are not being treated as numbers. Why<BR>
For some reason it did work in another instance (another ASP page I designed I was able to do sorting on EXCEL and other numeric stuff) but this particular one it is not doing the same. Would it be tags such as Missing tags etc... that could do it.