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 .