title: Change all negative values to 0
body: <p>I would like to set every negative value in a column of integers to <code>0</code>. That is, set it to 0 IN THE SAME CELL. Of course, I could just use MAX(cell,0) if I wanted a new column.</p>
  
  <p>I think Format Cells -> Format Code may do this, as it appears to support some kind of regex, but how do I replace any generic negative value with 0?</p>
  
  <p>I don't know the syntax and can't find any documentation on it. This is a custom format I tried:</p>
  
  <pre><code>#,##0.00;"0.00"
  </code></pre>
  
  <p>The problem is, it just masks the negative values as "0.00". It doesn't replace the VALUE with 0. Calculations assume that cell still contains the negative value.</p>