I have a series of workbooks that use an API to update table data. We have just switched to Office 365 and the date format on refreshing these is now reverting back to general for the newly imported data onwards. Previously we had date formats & custom date formats. Has anybody experience this and found any fix?

I've tried the following:

To save a new workbook
To go to Table Design>Properties>Selecting Preserve column sort/filter/layout
Tried changing the name of the applied steps in the query

Column formatting change.JPG

Many thanks,