Microsoft KB Archive/260239

= How To Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page =

Article ID: 260239

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Excel 2000 Service Pack 1
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Internet Explorer 4.0 128-Bit Edition
 * Microsoft Internet Explorer 4.01 Service Pack 2
 * Microsoft Internet Explorer 4.01 Service Pack 1
 * Microsoft Internet Explorer 4.01 Service Pack 2
 * Microsoft Internet Explorer 5.0
 * Microsoft Internet Explorer 5.01
 * Microsoft Internet Explorer 5.5
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q260239



SUMMARY
This article demonstrates how to format a field to preserve the leading digits (such as the &quot;000&quot; in &quot;0001112&quot;) or a specific formula when you create an Excel file with an Active Server Pages (ASP) page.



MORE INFORMATION
If you set the

Response.ContentType = &quot;application/vnd.ms-excel&quot;

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:

199841 How To Display ASP Results Using Excel in IE with MIME Types

If the table field has a leading zero, then the zero (or zeros) will be stripped because Excel treats the field as a numeric value.

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: <%@ Language=VBScript %> <%     'Change HTML header to specify Excel's MIME content type Response.Buffer = TRUE Response.ContentType = &quot;application/vnd.ms-excel&quot; %>     

