title: Set standard number format with thousand separator, 2 decimals and minus sign for negative numbers using VBA?
body: <p>I've seen the question asked before on stackoverflow, how to get normal number format with thousand separator and 2 decimals. The answer was to set:</p>
  
  <pre><code>    rng.NumberFormat = "##0.00"
  </code></pre>
  
  <p>But this is incomplete, because, at least on my computer, I don't get any space separator between millions and thousands. So I have changed that to:</p>
  
  <pre><code>    rng.NumberFormat = "### ### ##0.00"
  </code></pre>
  
  <p>But this is again incomplete, because for some reason negative numbers were formatted to look like they have a space between the minus sign and the number. See below:</p>
  
  <pre><code>- 12.4
  </code></pre>
  
  <p>So, there are some things left to do to arrive at Excels "built-in" "format as number" formats. Additionally the formatting that I apply though VBA is described as Custom by Excel.</p>
  
  <p>Is there any way to set the format to be the standard built in format as number with thousand separators, 2 decimals and minus signs for negative numbers?</p>
  
  <p>I'm looking for something like:</p>
  
  <pre><code>    rng.NumberFormat = "Number, 2, minus"
  </code></pre>