Forum Discussion
Power Query inserts wrong dates to Excel
Hello, I am trying to connect an external CSV-file and parse the data into Excel, so that I can use it there. The CSV-file contains one column of timestamps in the format of "yyyy-MM-dd hh:mm:ss...
About two months ago I experienced the issue where the PQ editor insisted on displaying dates in the US format. It completely ignored the system locale . And that was on both Mac and PC. I reported the bug and a few updates later (on the Insider program) the problem was gone on both platforms. Can't remember which update that was though and find nothing specific on it in the September/October release notes either.