title: Excel not inserting leading zero
body: <p>I am using Office OpenXml to write to an Excel file.  The file is a template so it already has all my headers and formatting for my columns.  I am inserting numbers that have leading zeroes to a "special" column which is basically a 10 digit number.  However in my code I can see that it is setting the value to for example <code>0000000004</code>.  The result in the sheet with a value of <code>4</code> in that cell and the actual cell showing <code>0000000004</code>.  </p>
  
  <p>Here is my code to write to the cell.</p>
  
  <pre><code>  if (reader[2].ToString().Length &lt; 9)
    {
  
  
          myworksheet.Cell(firstrow, 12).Value = reader[2].ToString(); //0045678945
  
    }
    else
    {
          myworksheet.Cell(firstrow, 12).Value = reader[2].ToString().Substring(0, 9); //0045678945
  
    }
  </code></pre>
  
  <p>when I open the excel sheet like I stated above my value is <code>45678945</code> instead of <code>0045678945</code></p>
  
  <p>Any help would be appreciated.</p>