Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2005

Tip: Looking for answers? Try searching our database.

Date format changing on mrg from Excel to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rebecca Dell - 16 Sep 2005 19:11 GMT
Hi there
In office 2003, I merge an excel list containing some dates to a word
document.  Sometimes (not every time), the date format changes from the
European version (e.g. 16/09/05) to the USA version (e.g. 09/16/05) in the
document, eventhough the European remains unchanged and correct in Word.  
I've checked my regional settings in control panel and I've checked the cell
date format is ok in Excel.

Any help would be appreciated.  I end up having to manually change each
merged document.

Rebecca
Graham Mayor - 17 Sep 2005 06:18 GMT
See http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi there
> In office 2003, I merge an excel list containing some dates to a word
[quoted text clipped - 8 lines]
>
> Rebecca

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.