title: Issue with decimal value 0.00 after exporting to Excel using c#
body: <p>I have some data that is exported to excel. In the below code When rowText = 4.0321, it shows same 4.0321 in excel. But if rowText = 0.00 it shows just 0 in the excel report. I need it to be 0.00. Any help would be appreciated..</p>
  
  <pre><code>                var rowText = base.GetColumnText(column, columnValue);
  
                  _writer.Write(string.Format("\"{0}\"", rowText.Replace("\"", "\"\"")));
  
                  _writer.Write(i &lt; columns.Count - 1 ? "," : Environment.NewLine);
  
  
  
  
      protected string GetColumnText(ViewColumn column, object value)
      {
          string text = string.Empty;
  
          if (value != null &amp;&amp; value != DBNull.Value)
          {
              var dataFormatString = column.DataFormatString;                
  
              if (string.IsNullOrEmpty(dataFormatString))
              {
                  switch (column.ColumnType)
                  {
                      case ViewColumnType.Date:
                          {
                              dataFormatString = "{0:MM/dd/yyyy}";
                          }
                          break;
                      case ViewColumnType.Numeric:
                          {
                              dataFormatString = "{0:N2}";
                          }
                          break;
                      case ViewColumnType.Account:
                          {
                              string AccountNo = value.ToString().Trim();
  
                              if (AccountNo.Length == 8)
                                  return string.Concat(AccountNo.Substring(0, 4), "-", AccountNo.Substring(4));
                          }
                          break;
                  }
              }
  
              text = !string.IsNullOrEmpty(dataFormatString) ? string.Format(dataFormatString, value) : value.ToString();
  
          }
          return text;
      }
  </code></pre>