xlColumnDataType

Specifies how a column is to be parsed.

xlDMYFormat(4)
xlDYMFormat(7)
xlEMDFormat(10)
xlGeneralFormat(1)
xlMDYFormat(3)
xlMYDFormat(6)
xlSkipColumn(9)
xlTextFormat(2)
xlYDMFormat(8)
xlYMDFormat(5)

xlDMYFormat
(4)
xlDYMFormat
(7)
xlEMDFormat
(10)
xlGeneralFormat
(1)
xlMDYFormat
(3)
xlMYDFormat
(6)
xlSkipColumn
(9)
xlTextFormat
(2)
xlYDMFormat
(8)
xlYMDFormat
(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.

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