Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
PersonWithAQuestion PersonWithAQuestion is offline
external usenet poster
 
Posts: 1
Default When I merge May 1, 2001, it merges as 5/1/2001. How do I fix?

My data source is an excel spreadsheet. The date column is formatted to
display November 11, 2009 but when I merge with my main document (Word
document), it displays the date as 11/11/2009 in merged document. What do I
need to do to keep the date displayed as November 11, 2009 after merge occurs?

Thank you.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default When I merge May 1, 2001, it merges as 5/1/2001. How do I fix?

Hi PersonWithAQuestion,

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 '\@ "MMMM d, yyyy"' to the field, as in {MERGEFIELD MyDate \@ "MMMM
d, yyyy"}. With this switch your date will come out as November 11, 2009'. Other possible date formatting switches include:
. \@ "dddd MMMM d, yyyy";
. \@ "ddd MMMM d, 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.


--
Cheers
macropod
[Microsoft MVP - Word]


"PersonWithAQuestion" wrote in message
...
My data source is an excel spreadsheet. The date column is formatted to
display November 11, 2009 but when I merge with my main document (Word
document), it displays the date as 11/11/2009 in merged document. What do I
need to do to keep the date displayed as November 11, 2009 after merge occurs?

Thank you.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mac 2001 -- disappearing pull downs, etc RRW Microsoft Word Help 0 September 14th 08 03:41 PM
Miscrosoft Word Mac 2000-2001 lisalou Microsoft Word Help 7 January 31st 07 06:39 PM
2001 printing problem with mac v10 [email protected] New Users 0 March 16th 06 07:17 PM
Word 2001 toolbar problems on Mac OS 9.2 Blue Heron Microsoft Word Help 1 January 31st 05 12:17 AM
Setting tool bars in Wod 2001 for Mac? SDenison Microsoft Word Help 1 December 9th 04 11:02 PM


All times are GMT +1. The time now is 08:32 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"