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
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
