Forum Discussion
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...
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)
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)