I am creating a page which contains a table with numeric values and by using the following code

Response.ContentType = "application/vnd.ms-excel"
        Response.Charset = ""
        Me.EnableViewState = False

        Dim tw As New System.IO.StringWriter
        Dim hw As New System.Web.UI.HtmlTextWriter(tw)

        PlaceHolder1.RenderControl(hw)

        Response.Write(tw.ToString)

        Response.End()

I am displaying the information in excel format. The problem is any leading zeros are not displayed. Any help would be gratefully received.

I sorted the problem in the end:

myCell.Controls.Add(New LiteralControl("=ASC(""" & myText & """)"))

mycell being the table cell.