Office 365 - Forms Export Settings & Date Format

[CPS-Stimmers]

We're starting to use MS Forms more and more on site, and all is good except for one small annoyance.

When exporting into Excel using the 'Open in Excel' option, it exports all the dates as US formatting instead of our UK format. I can confirm our Organisational settings, Chrome Settings and date selection options in Forms are all in UK format, and I have even tried changing my own language and region settings through my Delve profile. I've seen a few things online in my research, but has anyone else had or solved this problem?

 

Many Thanks!

[EssentialRug]

We're starting to use MS Forms more and more on site, and all is good except for one small annoyance.

When exporting into Excel using the 'Open in Excel' option, it exports all the dates as US formatting instead of our UK format. I can confirm our Organisational settings, Chrome Settings and date selection options in Forms are all in UK format, and I have even tried changing my own language and region settings through my Delve profile. I've seen a few things online in my research, but has anyone else had or solved this problem?

 

Many Thanks!

 

https://support.microsoft.com/en-us/office/change-regional-settings-for-a-site-e9e189c7-16e3-45d3-a090-770be6e83c1a

[CPS-Stimmers]

I had looked at that previously, however it seems like that is just on Sharepoint, our Organisational settings are set correctly and there doesnt seem to be any regional settings for MS Forms.

[EssentialRug]

I had looked at that previously, however it seems like that is just on Sharepoint, our Organisational settings are set correctly and there doesnt seem to be any regional settings for MS Forms.

 

Where are you storing your forms? You may have to change the regional settings for OneDrive if they are stored here.

 

Open OneDrive and click gear icon

OneDrive settings

More settings

Regional settings