Forum Discussion
How to standardize different time formats
Hi all, Stuck in a dilemma, unfortunately a report is sent to me with a a date column that has all kind of different formats. Here are the 3 types: Is there any formula or script that could stan...
I think the data comes from a csv/txt file and you *opened* it in Excel. Never do that.
The csv-file has only one date format in it. But it is different from date format on your system.
Always *import* csv-files via Power Query. You have the option to change the data type - even with the proper locale if necessary.