WksDateFmtType Values

The WksDateFmtType value is used by the worksheet when a date format is set with the SetDateTimeFmtType method or the DateFmtType property. The Value is also used by the Numeric Label Property Syntax for the DateFormat option.

Enumeration

Value

Display

Example

Description

wksDateFmt_NONE

0

(None)

36045

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, Double digit month and year, separated with .

wksDateFmt_D_P_MM_P_YYYY

39

d.mm.yyyy

7.09.1998

Single digit day, Double 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

1999-Sep-7

four digit year, shortened month name, single digit day, 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 .

See Also

Numeric Label Property Syntax