How do I retain my date formatting in Word? AAA Mailing 5/17/2007 3:22:08 PM When I run my mail merge, word is changing the format of the date. My excel spreadsheet has the date formatted as "May 17, 2007". After the mail merge is done, the date shows up in the body of the letter as "5/17/07". How can I make word retain my date formatting?

Re: How do I retain my date formatting in Word? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/17/2007 3:45:09 PM See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "AAA Mailing" <AAA Mailing[ at ]discussions.microsoft.com> wrote in message news:AD923964-DA5E-4A2F-89FA-11F1165AA5E1[ at ]microsoft.com... [Quoted Text] > When I run my mail merge, word is changing the format of the date. My > excel > spreadsheet has the date formatted as "May 17, 2007". After the mail > merge > is done, the date shows up in the body of the letter as "5/17/07". How > can I > make word retain my date formatting?