Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Quels sont .NumberFormat Options In Excel VBA?

ayi

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:
I know that we can set for example Text type as:
<pre><code class="lang-auto">.NumberFormat ="@"

</code></pre>
or for number:
<pre><code class="lang-auto">.NumberFormat = "0.00000"

</code></pre>
Can you please let me know what are other options for types in VBA?

ayi_2

Note this was done on Excel for Mac 2011 but should be same for Windows
Macro:
<pre><code class="lang-auto">Sub numberformats()
Dim rng As Range
Set rng = Range("A24:A35")
For Each c In rng
Debug.Print c.NumberFormat
Next c
End Sub

</code></pre>
Result:
<pre><code class="lang-auto">General General
Number 0
Currency $#,##0.00;[Red]$#,##0.00
Accounting ($* #,##0.00);($* (#,##0.00);($* "-"??);(@)
Date m/d/yy
Time [$-F400]h:mm:ss am/pm
Percentage 0.00%
Fraction # ?/?
Scientific 0.00E+00
Text @
Special ;;
Custom #,##0);Red

</code></pre>
(I just picked a random entry for custom)