title: Excel Date column returning INT using EPPlus
body: <p>So i'm using EPPlus to read and write excel documents.</p>
  
  <p>Workflow</p>
  
  <ul>
  <li>User generates populated excel document</li>
  <li>Opens document and adds a row</li>
  <li>Uploaded and read</li>
  </ul>
  
  <p>The dates that are generated when I create the document using EPPlus show correctly when I'm reading the value back but the row the user changes the date one or adds is showing as an INT value not something I can use as a real date. </p>
  
  <p>When I enter the date <strong>1/01/2014</strong> and write it, the output when I open the file up shows <strong>41640</strong></p>
  
  <p>I'm reading it as follows</p>
  
  <pre><code>sheet.Cells[i, "AE".ConvertExcelColumnIndex()].Value != null
       ? sheet.Cells[i, "AE".ConvertExcelColumnIndex()].Value.ToString().Trim()
           : string.Empty
  </code></pre>
  
  <p><strong><em>Update</em></strong></p>
  
  <p>When exporting the file I have added the following</p>
  
  <pre><code>DateTime testDate;
  
  if (DateTime.TryParse(split[i], out testDate))
  {
      sheet.Cells[row, i + 1].Style.Numberformat.Format = "MM/dd/yyyy";
      sheet.Cells[row, i + 1].Value = testDate.ToString("MM/dd/yyyy");
  }
  </code></pre>
  
  <p>Also when reading the value back I have tried</p>
  
  <pre><code>sheet.Cells[i, "AE".ConvertExcelColumnIndex()].Style.Numberformat.Format = "MM/dd/yyy";
  </code></pre>
  
  <p>I still get an INT back</p>