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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top