title: Can't format number in PHPExcel
body: <p>I'm using PHPExcel to print some money amount, and I need them to have 4 decimal numbers after comma, but I want to remove any trailing zero. For example, my input is:</p>
  
  <pre><code> Input: 11,1230 =&gt; Wanted output: 11,123
   Input: 0,0123  =&gt; Wanted output: 0,0123
   Input: 8,3200  =&gt; Wanted output: 8,32
   Input: 44,0000 =&gt; Wanted output: 44     &lt;--error is here
  </code></pre>
  
  <p>The problem is that I can't get rid of the trailing comma of <code>44,0000</code> which prints out as <code>44,</code></p>
  
  <p>I'm using the following command:</p>
  
  <pre><code>$activeSheet-&gt;getStyle("K10")-&gt;getNumberFormat()-&gt;setFormatCode('€ ####0.####');
  </code></pre>
  
  <p>All numbers print as expected except for those numbers without significant decimals value, like 44,0000. Any idea?</p>
  
  <p>EDIT: I know I can use MS Excel to achieve this, by using these buttons</p>
  
  <p><a href="https://i.stack.imgur.com/CGWhn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CGWhn.png" alt="enter image description here"></a> </p>
  
  <p>but I would prefer a PHP solution</p>