title: What are .NumberFormat Options In Excel VBA?
body: <p>Can you please let me know what are the <code>.NumberFormat</code> format options in Excel VBA? As you are fully aware Excel 2010 supports the following types:</p>
  <p><img src="https://i.stack.imgur.com/DDIQB.png" alt="enter image description here" /></p>
  <p>I know that we can set for example Text type as:</p>
  <pre><code>.NumberFormat =&quot;@&quot;
  </code></pre>
  <p>or for number:</p>
  <pre><code>.NumberFormat = &quot;0.00000&quot;
  </code></pre>
  <p>Can you please let me know what are other options for types in VBA?</p>