从Excel导出Excel列格式为十进制

Question

嗨，我正在使用以下方法将数据库导出到excel        Response.ClearContent();        Response.Buffer = true;        Response.AddHeader("content-disposition", "attachment; filename=" + FileName);        Response.ContentType = "application/vnd.ms-excel";        EnableViewState = false;        Response.Write("<style> TABLE { border:dotted 1px #999; } TH { border:dotted 1px #D5D5D5; text-align:center } TD { border:dotted 1px #D5D5D5; } </style>");        Response.Write("<table>");        Response.Write("<tr>");                  Response.Write("<th>Actual Estimated Price</th>");        Response.Write("<th>Aprroved Estimated Price </th>");        Response.Write("<th>Actual Price</th>");        Response.Write("<th>Aprroved Actual Price </th>");        Response.Write("<th>TransactionID </th>");                    Response.Write("<th>Created On</th>");        Response.Write("</tr>");        foreach (DataRow dr in dt.Rows)        {            Response.Write("<tr>");            Response.Write("<td>");            Response.Write(String.Format("{0:0.0#}", dr["EstimatedPriceTotal"].ToString()));            Response.Write("</td>");            Response.Write("<td>");            Response.Write(String.Format("{0:0.0#}", dr["ApprovedEstimatedPriceTotal"].ToString()));            Response.Write("</td>");            Response.Write("<td>");            Response.Write(String.Format("{0:0.0#}", dr["ActualPriceTotal"].ToString()));            Response.Write("</td>");            Response.Write("<td>");            Response.Write(String.Format("{0:0.0#}", dr["ApprovedActualPriceTotal"].ToString()));            Response.Write("</td>");            Response.Write("<td>");但我无法以excel格式导出excel中的实际估计价格，批准的估计价格该值显示为5，而不是显示5.00如何从C＃端将Excel的某些列格式化为十进制格式