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.

The problem is most likely due to having two different date formats in use in your data source (d/m/yyyy and m/d/yyyy - or a variation on those). US systems usually default to something based on m/d/yyyy but other regions typically use something based on d/m/yyyy. If you're using a UK system, for example, but are trying to input dates with a m/d/yyyy format, Excel won't know that a date input as 10/04/2012 is 4 October 2012 and not 10 April 2012 unless the cell is pre-formatted for d/m/yyyy dates. The converse also applies.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]