title: Excel interpreting 0% as a large number
body: <p>I am encountering a strange error when trying to use <code>VBA</code> to implement some formulas. Here is the formula I'm using to place "0.00%" instead of an error message in my cells:</p>
  
  <pre><code>ActiveWorkbook.Sheets("SM Summaries").Range("F6").FormulaR1C1 = "=IFERROR(RC[-2]/RC[-1], ""0.00%"")"
  </code></pre>
  
  <p>Now it places the 0.00% just fine, but even when its cell type is defined as percentage, if I sort largest to smallest by % it places the 0s at the top...</p>
  
  <p><a href="https://i.stack.imgur.com/I9PAb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/I9PAb.png" alt="Largest to smallest"></a>
  Here you can see where the 0s are placed on top even when doing largest to smallest. And the cell types are set properly to percentage as well:</p>
  
  <p><a href="https://i.stack.imgur.com/ZJTn5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZJTn5.png" alt="percentage"></a>
  Any idea what's going on here?</p>
  
  <p>I have also tried just placed in <code>0.00</code> instead of <code>0.00%</code> as well as <code>0%</code> and "0", all of those options still showing 0 as being considered a "large number". The only reason that they're not green in the picture above is because I set a conditional formatting rule to stop turning 0s green (when the number is greater than 1).</p>