| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlColumnDataType enumeration (Excel) |
|
034f6011-c860-0887-9661-857821f630e4 |
06/08/2017 |
medium |
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. |
[!includeSupport and feedback]