Date format in Power Query - Windows 10

[Nikelove]

Hi there,

I was recently updated to Windows 10 frm Windows 7 at work. My co-worker and I share a spread sheet in which we have to input info and refresh. All was well until I was updated.

The problem lies in the date format. In Windows 7 the existing power query using date.to.text fuction is dd/mm/yyy but on my Windows 10 it's then changed to yyy-mm-dd. Does any know why Windows 10 is reverting back to dashes instead of slashes?

All date formats have been checked and compared with the windows 7 option and it's all the same. But no matter how it's changed, Windows 10 changes it.

TIA

 

[sandy666]

maybe check: Control Panel - Region - Format and Date Time format (you can try UK : dd/mm/yyyy)