Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AAA Mailing AAA Mailing is offline
external usenet poster
 
Posts: 1
Default How do I retain my date formatting in Word?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I retain my date formatting in Word?

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 wrote in message
...
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?



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
Retain formatting of my data source using mail merge in Word? CRS Mailmerge 2 February 26th 07 09:35 PM
Switches in Table of Authorities - retain formatting does not retain character styles Charles Kenyon Formatting Long Documents 1 March 28th 06 10:06 AM
How do I get Word to retain Excel formatting, eg zip code, ssn? soxn4n04 Mailmerge 1 December 1st 05 04:52 AM
How do I retain formatting from an Excel Data File to a Word Merg. Pookas Microsoft Word Help 5 March 14th 05 10:32 PM
Word Templates don't retain formatting MizDee Microsoft Word Help 1 March 7th 05 10:44 PM


All times are GMT +1. The time now is 07:18 AM.

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

About Us

"It's about Microsoft Word"