Mail Merge Date Format
Since you want November, use MMMM
MMM will give you Nov
--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.
"whiter" wrote in message
:
Thanks Beth.
Now I am getting 11,15, 2007. My format in excel is November 15, 2007, do I
need to change this? Even if I select, prefer format under edit funtions,
then I get a totally different date format?
Rebecca
"Beth Melton" wrote:
Try using a capital "M" for the month instead of a lowercase "m". In Word a
lowercase m is for minutes. So what you need is: "MM, dd, yyyy".
Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Coauthor of Word 2007 Inside Out:
HYPERLINK "http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook"http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook
Word FAQ: HYPERLINK "http://mvps.org/word"http://mvps.org/word
TechTrax eZine: HYPERLINK "http://mousetrax.com/techtrax/"http://mousetrax.com/techtrax/
MVP FAQ site: HYPERLINK "http://mvps.org/"http://mvps.org/
"whiter" HYPERLINK "whiter@di scussions.microsoft.com wrote in message
...
I am having trouble with my date format in my mail merge.
I am using the date switch \@"mm,dd,yyy" but am still getting a #format.
It used to work before we changed to SP3 from SP2 in Office 2002.
HELP!
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.17.2/1184 - Release Date: 12/14/2007 11:29 AM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.17.2/1184 - Release Date:
12/14/2007 11:29 AM
|