XlColumnDataType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies how a column is to be parsed.

Name

Value

Description

xlDMYFormat

4

DMY date format.

xlDYMFormat

7

DYM date format.

xlEMDFormat

10

EMD date format.

xlGeneralFormat

1

General.

xlMDYFormat

3

MDY date format.

xlMYDFormat

6

MYD date format.

xlSkipColumn

9

Column is not parsed.

xlTextFormat

2

Text.

xlYDMFormat

8

YDM date format.

xlYMDFormat

5

YMD date format.

Show: