title: How to format exponent to number from Export to excel?
body: <p>I am exporting data table to excel and one column is having Phone number in the data table but after export in Excel the phone number coloumn is displaying as exponent.</p>
  
  <p>I need as number, How to fix this ?</p>
  
  <pre><code> string fileName = "File" + DateTime.Now.ToString("MMddyyyy_HHmmss") + ".xls";
          Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
          //Response.AddHeader("content-disposition", "attachment;filename=File.xls");
          Response.ContentType = "application/vnd.ms-excel";
  
          StringWriter stringWriter = new StringWriter();
          HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWriter);
          DataGrid dataExportExcel = new DataGrid();
          dataExportExcel.ItemDataBound += new DataGridItemEventHandler(dataExportExcel_ItemDataBound);
          dataExportExcel.DataSource = dt;
          dataExportExcel.DataBind();
          dataExportExcel.RenderControl(htmlWrite);
          System.Text.StringBuilder sbResponseString = new System.Text.StringBuilder();
          sbResponseString.Append("&lt;html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:xlExcel8\" xmlns=\"http://www.w3.org/TR/REC-html40\"&gt; &lt;head&gt;&lt;/head&gt; &lt;body&gt;");
          sbResponseString.Append(stringWriter + "&lt;/body&gt;&lt;/html&gt;");
          Response.Write(sbResponseString.ToString());
          Response.End();
  </code></pre>