title: The Excel cell type is 'Numeric' but still it appears as 'General'
body: <p>I am using OpenXML spreadsheet package in C# to convert <code>datatable</code> to excel. In code I am writing this to append cells with Numeric Type:</p>
  
  <pre><code> public void MakeNumericCell(string cellReference, string cellStringValue, Row excelRow)
   {
  
      //  Add a new Excel Cell to our Row 
      Cell cell = new Cell() { CellReference = cellReference, DataType=CellValues.Number };
      CellValue cellValue = new CellValue(cellStringValue);       
      cell.Append(cellValue);
      excelRow.Append(cell);
  
   }
  </code></pre>
  
  <p><strong>Please note that I am not asking <a href="https://stackoverflow.com/questions/24256243/changing-datatype-of-cell-to-double">How to convert Text cell to Number</a> or <a href="https://stackoverflow.com/questions/6412957/changing-excel-cell-format-in-c-sharp">change data type (format) of Excel Cell</a></strong> whose answer already exists on SO.</p>
  
  <p>In my case, the cells <strong>do</strong> convert to number format in excel sheet. I can find the type of Excel cell by using formula <code>=Type(Cell)</code> which returns 1 if the cell type is numeric. As shown in image, the last column (name of column is <code>Type of Cell</code>) is evaluated using <code>=Type(cell)</code> formula which returns 1 for the <code>C</code> column, but the it still appears in <code>General</code> as highlighted in the image.</p>
  
  <p>Am I doing something wrong here? Or is it an issue in Excel itself?</p>
  
  <p><a href="https://i.stack.imgur.com/Fmyp9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fmyp9.png" alt="Numeric cells appear as General"></a></p>