Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I have been mail merging a letter in word, but no matter how I format the
cells in Excel, the date field appears in the US format, and I need it in the UK style. Can anyone help? |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi Christina,
You can get the date to display correctly by editing the mailmerge field in Word. To do this, select the errant field and press Shift-F9. It sould look like '{MERGEFIELD ExcelDate}'. Add a picture switch to the field, thus: '{MERGEFIELD ExcelDate \@ "d MMM yyyy"}', then press F9 to update the field. You will now have dates appearing as '15 Nov 2008'. Other date switch options include: \@ "dd/MM/yyyy" for 15/11/2008 \@ "dddd, d MMMM yyyy" for Thursday, 15 November 2008 and so on. Basically, the switch parameters do the same as in Excel, See Word's help file on field switches for more info. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "christina_b123" wrote in message ... I have been mail merging a letter in word, but no matter how I format the cells in Excel, the date field appears in the US format, and I need it in the UK style. Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merging Excel to word. How to stop Date changing into US format. | Mailmerge | |||
mail merging date fields from excel | Mailmerge | |||
HELP!!! Date not in correct UK format when merging from Excel | Mailmerge | |||
Excel date format merging to Word XP version | Mailmerge | |||
Date issue merging from Excel field in Date format to Word | Mailmerge |