[Fi]

I have an excel datasource with dates formatted to show e.g. 5th June 2007.

However when I merge the datasource in Word and insert the date field it
shows as 06/05/2007.

I am using Office 2003 on XP. My regional settings are set to UK. Is this
common to set the date to American format. Is there a way to edit the mail
merge field format to show the correct date format?

[Peter Jamieson]

Is this
common to set the date to American format.

It is certainly what usually happens in this particular case.

In this case you should be able to change a mergefield such as

{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"DD/MM/YY" }

(use Alt-F9 to display the field codes so you can edit them. You can usually
reasonably safely delete "\*Mergeformat" if you see it)

I'd then verify that "ambiguous" dates where the day number is 12 or below
are not reversed.

Peter Jamieson

"Fi" wrote in message
...
I have an excel datasource with dates formatted to show e.g. 5th June 2007.

However when I merge the datasource in Word and insert the date field it
shows as 06/05/2007.

I am using Office 2003 on XP. My regional settings are set to UK. Is
this
common to set the date to American format. Is there a way to edit the
mail
merge field format to show the correct date format?