title: C# - format column when writing to CSV file(cell formatting)
body: <p>Have written the method for the exporting the data to csv files.
    If the value of the cell has <code>DEC20</code> in csv is getting as <code>20-Dec</code> which is not correct.</p>
  
  <p>My code is like this:</p>
  
  <pre><code>for (int i = 0; i &lt; myData.Count(); i++)
  {
      sb.AppendLine(string.Join(delimiter, 
                                Common.FormatExportString(myData[i].Code),
                                Common.FormatExportString(myData[i].Name),
                                Common.FormatExportString(myData[i].Description)));
  }
  //returns the file after writing the stream to the csv file.
  return File(new System.Text.UTF8Encoding().GetBytes(sb.ToString()), "text/csv", fileName);
  </code></pre>
  
  <p>Kindly help me to get the exact <code>string</code> format to be displayed in the excel (csv) file using C#.</p>
  
  <p>Ex: 
  myData[i].Name data will be </p>
  
  <blockquote>
    <p>DEC20, or 2-5</p>
  </blockquote>
  
  <p>like this,</p>
  
  <p>but the output in csv(excel) is getting displayed as </p>
  
  <blockquote>
    <p>20-Dec and 5-May</p>
  </blockquote>
  
  <p>instead of the original one.</p>