xlColumnDataType

Specifies how a column is to be parsed.

xlDMYFormat	DMY date format (4)
xlDYMFormat	DYM date format (7)
xlEMDFormat	EMD date format (10)
xlGeneralFormat	General (1)
xlMDYFormat	MDY date format (3)
xlMYDFormat	MYD date format (6)
xlSkipColumn	Column is not parsed (9)
xlTextFormat	Text (2)
xlYDMFormat	YDM date format (8)
xlYMDFormat	YMD date format (5)

xlDMYFormat

DMY date format (4)

xlDYMFormat

DYM date format (7)

xlEMDFormat

EMD date format (10)

xlGeneralFormat

General (1)

xlMDYFormat

MDY date format (3)

xlMYDFormat

MYD date format (6)

xlSkipColumn

Column is not parsed (9)

xlTextFormat

Text (2)

xlYDMFormat

YDM date format (8)

xlYMDFormat

YMD date format (5)

REMARKS

* Added in 2000.
* You can use xlEMDFormat only if Taiwanese language support is installed and selected. The xlEMDFormat constant specifies that Taiwanese era dates are being used.