Forum Discussion

Microsoft

Feb 09, 2017

Solved

January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

Hi friends, We have recently announced the January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in. In this update, we have released the following features: ...

BI & Data Analytics

Get & Transform Data

SergeiBaklan
Feb 21, 2017
Daniel, perhaps this discussion will help https://social.technet.microsoft.com/Forums/en-US/db5efab1-be7b-4541-be73-b24682796d6c/how-to-get-the-latest-power-query-for-microsoft-office-professional-plus-2016?forum=powerquery

Carel van Lange

Copper Contributor

Feb 08, 2018

In the old tool for importing data from a CSV-file it was easy to select a column with a JMD date in it (eg totday: 180208) and convert this into an actual date in Excel. I cannot find the way how to do this in the new interface.

Guy Hunkin
Microsoft
Feb 13, 2018
Hi,

Power Query works in a slightly different way and uses locale for date conversions. Take a look at the following article for more details:

https://support.office.com/en-us/article/internationalization-power-query-d42b9390-1fff-413f-8120-d7df0ced20b9

Hope it helps.

Guy.

- Excel Team