Mail merging a date from excel, appears as US format not UK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christina_b123 - 15 Nov 2007 09:29 GMT

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 to this Message

macropod - 15 Nov 2007 09:57 GMT

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

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>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 to this Message