title: Number format in Pentaho Data Integration
body: <p>I'm using Pentaho Data Integration Version: 8.0.0.0-28.</p>
  
  <p>Steps used in transformation:</p>
  
  <ul>
  <li><strong>Table input</strong> (Connection: MySQL database)</li>
  <li><strong>Select values</strong></li>
  <li><strong>Insert/ Update</strong> (Connection: MySQL database with the same data types as the input)</li>
  </ul>
  
  <p>The input table has a column containing DOUBLE values.
  I want to always keep two digits after the '<strong>.</strong>', examples:</p>
  
  <pre><code>1587.657 -&gt; 1587.65
  32.5 -&gt; 32.50
  693 -&gt; 693.00
  0 -&gt; 0.00
  </code></pre>
  
  <p>I tried to change the format in the <strong>Select values</strong> step selecting <strong>0.00</strong> in the <strong>meta-data</strong> <strong>format</strong> field. It works when I click on <strong>preview</strong>. The problem is when I check the output table nothing happens.</p>
  
  <p>Any suggestions?</p>