Hi, when I refresh with new data the date format is incorrect, see below in yellow. I have to select the columns and manually format as 'Date' in the excel worksheet after I refresh. I originally created the power query in MS 2016 and now use it in MS 365, could that be the problem? Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Query date format incorrect
- Thread starter 571202
- Start date
Upvote
0
Excel Facts
Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Similar threads
- Solved
