What are .NumberFormat Options In Excel VBA?

Question

Can you please let me know what are the .NumberFormat 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:

.NumberFormat ="@" 

or for number:

.NumberFormat = "0.00000" 

Can you please let me know what are other options for types in VBA?

Answer 1

Note this was done on Excel for Mac 2011 but should be same for Windows

Macro:

Sub numberformats()   Dim rng As Range   Set rng = Range("A24:A35")   For Each c In rng     Debug.Print c.NumberFormat   Next c End Sub 

Result:

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](#,##0) 

(I just picked a random entry for custom)