Merging Excel to word. How to stop Date changing into US format.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackieblue - 01 Oct 2007 14:06 GMT

I am currently merging details from an Excel spreadsheet into a Word Table.
I have tried everything to stop the date format changing for UK to US format.
I would prefer the long date format, eg 01-Oct-07, but cannot see how to
prevent it becoming 10/1/07. Suggestions much appreciated.

Reply to this Message

macropod - 01 Oct 2007 21:32 GMT

Hi Jackieblue,

You can fix this by adding a date picture switch to the mergefield. To do so:
. select the problem Word MERGEFIELD and press Shift-F9. You should see something like-
{MERGEFIELD ExcelDate}
. edit the field to look like-
{MERGEFIELD ExcelDate \@ "dd-MMM-yy"}
. press F9
. run your mailmerge.

Cheers

Signature

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

>I am currently merging details from an Excel spreadsheet into a Word Table.
> I have tried everything to stop the date format changing for UK to US format.
> I would prefer the long date format, eg 01-Oct-07, but cannot see how to
> prevent it becoming 10/1/07. Suggestions much appreciated.

Reply to this Message