Mail merge date format

[Highlander01]

I am seeking some help if at all possible.

I am using MS Office 2010.

I have a document saved in MS 2010 format with a number of date fields. My data source is an Excel spread sheet.

I am well aware of how it should work using switches. Some of the dates appear as they should "dd/mm/yyyy" (UK format) without the switch and others don't. for those that do require changing to UK format I am entering the switch \@"dd/MM/yyyy" next to the merged field name followed by F9 to save updates and then saving the template. For some reason when I go back into the template and attach my data source some of the dates have reverted back to the US format.



Any help or a work round would be appreciated.