Date Format in Merged document

[Jon]

In my letter I have «Date». I also have that column in my Excel database. In
my database the date is formatted as November, 27, 2007, but when I merge the
documents the date is shown as 11/27/2007. I don't see any way to adjust the
formatting. Thanks for any help.

 

[Clive Huggan]

Hello Jon,

Drag across the date field in your letter and key Shift-F9. The field coding
is revealed: it will include M/d/yyyy. Change that (by keying) to MMMM d,
yyyy -- then key Shift-F9 again. Select and key F9 to update it.

Cheers,

Clive Huggan
Canberra, Australia
(My time zone is 5-11 hours different from North America and Europe, so my
follow-on responses to those regions can be delayed)
============================================================
* SUGGESTION -- KEEP REVISITING AFTER YOU POST: If you post a question, keep
re-visiting the newsgroup for several days after the first response comes
in. Sometimes it takes a few responses before the best or complete solution
is provided; sometimes you'll be asked for further information.
=============================================================

 

[Jon]

Thanks, but I'm not getting this. I may not understand your instructions. I
am in Word 2003. If I drag across the date field and hold down the shift key
and the F9 key I get {MERGEFIELD"Date"}

I do not see any field coding.

 

[Clive Huggan]

Jon,

You've landed in a discussion group for users of Mac versions of Word (not
your fault: it's a charming foible of Microsoft's web interface, which I
guess you used). Mac versions differ variously from PC versions. Although
several people here use both PCs and Macs and may give you an answer soon,
it's likely that more people in a PC group have experienced your specific
problem. Here's where all the groups are listed:
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Cheers,
Clive Huggan
============

 

[John McGhie]

Look up "Switches" in the Help for the Merge Fields. You can specify a
switch to control the date formatting.

In my letter I have «Date». I also have that column in my Excel database. In
my database the date is formatted as November, 27, 2007, but when I merge the
documents the date is shown as 11/27/2007. I don't see any way to adjust the
formatting. Thanks for any help.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]