ExcelBanter - Text Import Wizard

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text Import Wizard (https://www.excelbanter.com/excel-discussion-misc-queries/101646-text-import-wizard.html)

Duncan Help

Text Import Wizard

Is there a way to have Column data format for the Date to always come up MDY
instead of DMY when I start the wizard?

Lamb Chop

Text Import Wizard

If you change your date format in windows (control panel Regional Options
Date, Short Date format as d-m-yyyy) you will always end up with dmy format.

"Duncan Help" wrote in message
...
Is there a way to have Column data format for the Date to always come up
MDY
instead of DMY when I start the wizard?

All times are GMT +1. The time now is 04:47 PM.