title: converting text in to number format in phpexcel
body: <p>I have made this sheet using PHPExcel 
  i filled it using an array . </p>
  
  <p>it has values in percent form and it treated as text form by default .
  how can i convert my all the columns in to numeric form for so i can apply some math formulas on it .</p>
  
  <pre><code>   $excel_out_Questions = $this-&gt;outputQuestions($Sets);
  
     $objPHPExcel-&gt;getActiveSheet()-&gt;fromArray($excel_out_Questions, "" , 'A5');
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/ktKuw.png" alt="excel sheet after filling"></p>
  
  <p>i have tried this but it doesn't work ... :/</p>
  
  <pre><code>  $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('B434:B444')-&gt;getNumberFormat()-&gt;setFormatCode (PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00);
  
  $objPHPExcel-&gt;getActiveSheet()-&gt;setCellValue( 'B445','=(SUM(B443:B444)-SUM(B434:B440))*100)');
  </code></pre>
  
  <p>Please suggest. </p>
  
  <p>Thanks in advance</p>