asp writing to a excel spreadsheet changing number to text

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dmanning
    New Member
    • Sep 2006
    • 1

    asp writing to a excel spreadsheet changing number to text

    i have an ASP application running ok with a exception that the numbers all coming out as text so no totals can be done. i'm using the code
    if Request.Form("H ist") ="1" then
    Response.Conten tType = "applicatio n/vnd.ms-excel"
    end if
    but recently the first row is only (numeric) after that all the number columns are text. is there a work around. i using asp server windows 200 server and html we upgraded to ms office 2003 about 8 months ago.
Working...