Forum Discussion
How to convert date format from imported data?
Dear community, with Office 2010 I usually imported csv data in US format into my German Excel sheet and in the 3rd step of the import wizzard I changed the Date Format from DMY to MDY, so that 09.0...
Leo_DE165 , you may use old wizard as well if you add it in options
and use in Data->Get data->Legacy Wizards
In Power Query (new wizard) you shall edit the query before loading, select column with date and from right click menu Change type->Using locale
SergeiBaklan Thank you very much for your fast and good response. It solved my problem! Great!!
Leo_DE165 , you are welcome
