xlColumnDataType

Specifies how a column is to be parsed.

xlDMYFormatDMY date format (4)
xlDYMFormatDYM date format (7)
xlEMDFormatEMD date format (10)
xlGeneralFormatGeneral (1)
xlMDYFormatMDY date format (3)
xlMYDFormatMYD date format (6)
xlSkipColumnColumn is not parsed (9)
xlTextFormatText (2)
xlYDMFormatYDM date format (8)
xlYMDFormatYMD 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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top