Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged Date Field Converting from Australian layout to American
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged Date Field Converting from Australian layout to American
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] "JayJay" wrote in message ... 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! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged Date Field Converting from Australian layout to America
Hi Macropod,
Thank you so, so ,so much - You're a legend!! It worked a treat! Thanks again :-) JayJay "macropod" wrote: 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] "JayJay" wrote in message ... 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you edit a merged date field? | Mailmerge | |||
IF then with merged date field from excel | Mailmerge | |||
how do change the american date to the european date? | Mailmerge | |||
How do I change my spell check to Australian English not American. | Microsoft Word Help | |||
How do I prevent a merged date field from wrapping? | Mailmerge |