Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How To Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page
Article ID: 260239 - View products that this article applies to.
This article was previously published under Q260239
This article demonstrates how to format a field to preserve the leading digits (such as the "000" in "0001112") or a specific formula when you create an Excel file with an Active Server Pages (ASP) page.
If you set the
in an ASP page, Excel will be launched to process the document and display it as an Excel spreadsheet. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
Response.ContentType = "application/vnd.ms-excel"
199841If the table field has a leading zero, then the zero (or zeros) will be stripped because Excel treats the field as a numeric value.
(http://support.microsoft.com/kb/199841/EN-US/ )How To Display ASP Results Using Excel in IE with MIME Types
You can specify the cell as a string value to preserve the format in the ASP page. You can even specify the formula for calculation in your code.
The following page, Test.asp, demonstrates how you can do this:
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/247318/EN-US/ )BUG: Word 2000 and Excel 2000 Do Not Redirect Correctly When Using Response.Redirect
(http://support.microsoft.com/kb/264143/EN-US/ )FIX: ASP Session Variables Empty When Office 2000 MIME Types Are Streamed with Internet Explorer
Article ID: 260239 - Last Review: February 12, 2007 - Revision: 2.2