This project has moved and is read-only. For the latest updates, please go here.

Open XML offers predefined formats for dates and numbers. The applied format will change according to the culture of the machine. For example NumberFormatId 2 for US will separate the decimal places with a dot yet the same file opened with a DE locale will display a comma.

You can use these codes in the following way:

range.Style.NumberFormat.NumberFormatId = #;

 

ID Format Code
0 General
1 0
2 0.00
3 #,##0
4 #,##0.00
9 0%
10 0.00%
11 0.00E+00
12 # ?/?
13 # ??/??
14 d/m/yyyy
15 d-mmm-yy
16 d-mmm
17 mmm-yy
18 h:mm tt
19 h:mm:ss tt
20 H:mm
21 H:mm:ss
22 m/d/yyyy H:mm
37 #,##0 ;(#,##0)
38 #,##0 ;[Red](#,##0)
39 #,##0.00;(#,##0.00)
40 #,##0.00;[Red](#,##0.00)
45 mm:ss
46 [h]:mm:ss
47 mmss.0
48 ##0.0E+0
49 @

 

M/d/yyyy

Last edited Sep 23, 2011 at 9:59 PM by MDeLeon, version 5