[macropod[_2_]]

Hi Gil5563,

To get the date format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM
yyyy"}. With this switch your date will come out as '2 August 2008'. Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy";
Note: Note: you can swap the d, M, y expressions around, but you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: Peter's '\#' switch won't work.


--
Cheers
macropod
[Microsoft MVP - Word]


"Gil5563" wrote in message ...
Have had excel and word 2003 installed on my PC at my place of work. Do a lot
of mailmerges.
Everything OK except when I mail merge using a date field in the SS (not
using the "today's date" update on word, - which works fine) which reverses
my UK date to US date i.e 24/02/2010 to 02/24/2010. The date appears
normally in the excel spreadsheet - until it is merged. I have tried re
formatting the cells and I have checked all the settings and they appear to
be set for English Uk - so I don't know what else to do!!

Any ideas please?