|
[Quoted Text] > 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 \[ at ]"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" <Fi[ at ]discussions.microsoft.com> wrote in message
news:B60D6C6D-D3F2-4E0C-A289-DD56F59936F1[ at ]microsoft.com...
>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?
|