Merged Date Field Converting from Australian layout to American

[JayJay]

I'm trying to do a mail merge letter, however, when I try and merge a date
from Excel spreadsheet to Word it converts the date from Australian layout
(dd/mm/yyyy) to US layout (mm/dd/yyyy). Is there any way I can change the
layout of the date? I've tried but I'm not getting anywhere. The date in
the spreadsheet is the correct layout (dd/mm/yyyy) but it changes when it
comes across.

Thanks!

 

[macropod]

Hi Jayjay,

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 like '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: you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

 

[JayJay]

Hi Macropod,

Thank you so, so ,so much - You're a legend!!

It worked a treat!

Thanks again

JayJay

Hi Jayjay,

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 like '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: you must use uppercase 'M's for months.
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

--
Cheers
macropod
[MVP - Microsoft Word]

I'm trying to do a mail merge letter, however, when I try and merge a date
from Excel spreadsheet to Word it converts the date from Australian layout
(dd/mm/yyyy) to US layout (mm/dd/yyyy). Is there any way I can change the
layout of the date? I've tried but I'm not getting anywhere. The date in
the spreadsheet is the correct layout (dd/mm/yyyy) but it changes when it
comes across.

Thanks!