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
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
