Forum Discussion

Iron Contributor

Mar 30, 2022

Solved

MS Forms to excel - UK format

Hi, When I use MS Forms, is there a way when i down the results to excel that the format can be in UK format (dd/mm/yy). Funnily enough in the excel bar it shows correctly but in the field its in...

microsoft forms

RobElliott
Mar 30, 2022
Mondas unfortunately you can't force the exel date columns in Forms into UK format. You would either need to save the spreadsheet to a different location then format the cells or, as we always do at my company, build a flow in Power Automate to save the responses to a SharePoint list where the SharePoint site is set to a UK date format.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott

Silver Contributor

Mar 30, 2022

Mondas unfortunately you can't force the exel date columns in Forms into UK format. You would either need to save the spreadsheet to a different location then format the cells or, as we always do at my company, build a flow in Power Automate to save the responses to a SharePoint list where the SharePoint site is set to a UK date format.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)