WksDateFmtType Values
The WksDateFmtType value is used by the worksheet when a date format is set with the SetDateTimeFmtType method or the DateFmtType property.
Enumeration |
Value |
Display |
Example |
Description |
WksDateFmt_NONE |
0 |
(None) |
|
Date not displayed |
WksDateFmt_M_D |
1 |
m/d |
9/7 |
Single digit month and day, separated with / |
WksDateFmt_M_D_YY |
2 |
m/d/yy |
9/7/98 |
Single digit month and day, two digit year, separated with / |
WksDateFmt_MM_DD_YY |
3 |
mm/dd/yy |
09/07/98 |
Double digit month, day, and year, separated with / |
WksDateFmt_D_MON |
4 |
d-mmm |
7-Sep |
Single digit day, shortened month name, separated with - |
WksDateFmt_D_MON_YY |
5 |
d-mmm-yy |
7-Sep-98 |
Single digit day, shortened month name, two digit year, separated with - |
WksDateFmt_DD_MON_YY |
6 |
dd-mmm-yy |
07-Sep-98 |
Double digit day, shortened month name, two digit year, separated with - |
WksDateFmt_MON_YY |
7 |
mmm-yy |
Sep-98 |
Shortened month name, two digit year, separated with - |
WksDateFmt_MONTH_YY |
8 |
mmmm-yy |
September-98 |
Full month name, two digit year, separated with - |
WksDateFmt_MONTH_D_YYYY |
9 |
mmmm-d-yyyy |
September-7-1998 |
Full month name, single digit day, full year, separated with - |
WksDateFmt_M |
10 |
mmmmm |
S |
First letter of month name |
WksDateFmt_M_YY |
11 |
mmmmm-yy |
S-98 |
First letter of month name, two digit year, separated with - |
WksDateFmt_M_D_YYYY |
12 |
m/d/yyyy |
9/7/1998 |
Single digit month and day, full year, separated with / |
WksDateFmt_D_MON_YYYY |
13 |
d-mmm-yyyy |
7-Sep-1998 |
Single digit day, shortened month name, full year, separated with - |
WksDateFmt_D_MONTH_YYYY |
14 |
d mmmm yyyy |
7 September 1998 |
Single digit day, full month name, full year, separated with spaces |
WksDateFmt_D_P_M_P_YY |
15 |
d.m.yy |
7.9.98 |
Single digit day and month, two digit year, separated with . |
WksDateFmt_DD_MM_YYYY |
16 |
dd/mm/yyyy |
07/09/1998 |
Double digit day and month, full year, separated with / |
WksDateFmt_DASH_MM_DD_YY |
17 |
mm-dd-yy |
09-07-98 |
Double digit month and day, two digit year, separated with - |
WksDateFmt_MON_D |
18 |
mmm-d |
Sep-7 |
Shortened month name, single digit day, separated with - |
WksDateFmt_MON_DD_YYYY |
19 |
mmm dd, yyyy |
Sep 07, 1998 |
Shortened month name, double digit day, full year, separated with spaces and comma |
WksDateFmt_MONTH_DD_YYYY |
20 |
mmmm dd, yyyy |
September 07, 1998 |
Full month name, double digit day, full year, separated with spaces and comma |
WksDateFmt_MON_YYYY |
21 |
mmm-yyyy |
Sep-1998 |
Shortened month name, full year, separated with - |
WksDateFmt_MONTH_YYYY |
22 |
mmmm-yyyy |
September-1998 |
Full month name, full year, separated with - |
WksDateFmt_YYYY |
23 |
yyyy |
1998 |
Full year |
WksDateFmt_YY |
24 |
yy |
98 |
Two digit year |
WksDateFmt_MONTH |
25 |
mmmm |
September |
Full month name |
WksDateFmt_MON |
26 |
mmm |
Sep |
Shortened month name |
WksDateFmt_MM |
27 |
mm |
09 |
Double digit month |
WksDateFmt_MNUM |
28 |
m |
9 |
Single digit month |
WksDateFmt_DD |
29 |
dd |
07 |
Double digit day |
WksDateFmt_DNUM |
30 |
d |
7 |
Single digit day |
WksDateFmt_DAYOFWEEK |
31 |
dddd |
Monday |
Full day of week name |
WksDateFmt_DOW |
32 |
ddd |
Mon |
Shortened day of week name |
WksDateFmt_YY_MM_DD |
33 |
yy/mm/dd |
98/09/07 |
Two digit year, double digit month and day, separated with / |
WksDateFmt_DASH_YYYY_MM_DD |
34 |
yyyy-mm-dd |
1998-09-07 |
Full year, double digit month and day, separated with - |
WksDateFmt_SLASH_D_MNUM_YY |
35 |
d/m/yy |
7/9/98 |
Single digit day and month, two digit year, separated with / |
WksDateFmt_SLASH_DD_MM_YY |
36 |
dd/mm/yy |
07/09/98 |
Double digit day and month, two digit year, separated with / |
WksDateFmt_D_P_M_P_YYYY |
37 |
d.m.yyyy |
7.9.1998 |
Single digit day and month, four digit year, separated with . |
WksDateFmt_D_P_MM_P_YY |
38 |
d.mm.yy |
7.09.98 |
Single digit day, two digit month and year, separated with . |
WksDateFmt_D_P_MM_P_YYYY |
39 |
d.mm.yyyy |
7.09.1998 |
Single digit day, two digit month, four digit year, separated with . |
WksDateFmt_D_P_MON_P_YY |
40 |
d.mmm.yy |
7.Sep.98 |
Single digit day, shortened month name, two digit year, separated with . |
WksDateFmt_D_P_MON_P_YYYY |
41 |
d.mmm.yyyy |
7.Sep.1998 |
Single digit day, shortened month name, four digit year, separated with . |
WksDateFmt_YYYY_M_D |
42 |
yyyy/m/d |
1998/9/7 |
four digit year, single digit month and day, separated with / |
WksDateFmt_YYYY_MON_D |
43 |
yyyy/mmm/d |
1998/Sep/7 |
four digit year, shortened month name, single digit day, separated with / |
WksDateFmt_DASH_YYYY_M_D |
44 |
yyyy-m-d |
1998-9-7 |
four digit year, single digit month and day, separated with - |
WksDateFmt_DASH_YYYY_MON_D |
45 |
yyyy-mmm-d |
1998-Sep-7 |
four digit year, shortened month name, separated with - |
WksDateFmt_YYYY_P_M_P_D |
46 |
yyyy.m.d |
1998.9.7 |
four digit year, single digit month and day, separated with . |
WksDateFmt_YYYY_P_MON_P_D |
47 |
yyyy.mmm.d |
1998.Sep.7 |
four digit year, shortened month name, single digit day, separated with . |