Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Date fields
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Date fields
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 merge field format to show the correct date format? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word converts English date to USA date in mail-merge from Excel? | Mailmerge | |||
Using mail merge date fields in headers | Mailmerge | |||
Using date fields in merge | Mailmerge | |||
mail merging date fields from excel | Mailmerge | |||
Merge date fields | Mailmerge |