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...
Another thought is that it may be possible to address the problem by changing the workflow. If dates were not imported directly to Excel but, instead first taken into PowerQuery as text, the conversion to date can be done using the required source data locale. Loading to an Excel table should then be error free.