title: Remove first character if it is "0" (Zero)
body: <p>I couldn't get the correct formula in order to remove the leading zero in a column. I built the following, but it returns <code>FALSE</code> instead of the value without zero:</p>
  
  <pre><code>=IF(RIGHT(Z2:Z19497,LEN(Z2:Z19497)-1)="0",MID(Z2:Z19497,2,LEN(Z2:Z19497)))
  </code></pre>
  
  <p>Hope you can help.</p>