title: number cell format with text
body: <p>I want to export my data to excel using phpspreadsheet but my data is number in 12 character. So I need to display all the character (121212121212) instead of (1.21212E+11).</p>
  
  <p>I have try the format using</p>
  
  <pre><code>PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT
  </code></pre>
  
  <p>and</p>
  
  <pre><code>PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER
  </code></pre>
  
  <p>It doesn't work.</p>
  
  <p>This is my cell formatting code:</p>
  
  <pre><code>$spreadsheet-&gt;getActiveSheet()-&gt;getStyle('B')-&gt;getNumberFormat()
      -&gt;setFormatCode(PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
  </code></pre>
  
  <p>This is my value insert code:</p>
  
  <pre><code>$sheet-&gt;setCellValue('A'.$i, $i-1);
          $sheet-&gt;setCellValue('B'.$i, $useric);
  </code></pre>
  
  <p>If I use the FORMAT_TEXT the result is this:</p>
  
  <pre><code>![result](https://i.imgur.com/6xxKDkv.png)
  </code></pre>