title: Comma separated values show with out float(.00) number in PHPExcel
body: <p>I am converting a PHP script into excel sheet using PHPExcel library I want comma separated values without floating number (<code>.00</code>).</p>
  
  <p>I am using following script:</p>
  
  <pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle("A1")-&gt;getNumberFormat()-&gt;setFormatCode
  (PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
  
  $objPHPExcel-&gt;getActiveSheet()-&gt;setCellValueExplicit("A1",(1111111),
  PHPExcel_Cell_DataType::TYPE_NUMERIC);
  </code></pre>
  
  <p>But when I convert the file in PHPExcel result show <code>1,111,111.00</code> but I want is <code>1,111,111</code> .</p>
  
  <p>Is there any way?</p>