Reply
 
Thread Tools Display Modes
  #1   Report Post  
GayleT
 
Posts: n/a
Default Excel dates formatted d/m/yy convert to m/d/yy in mail merge

When I use an excel spreadsheet as a data source for a word mail merge my
dates that are formatted d/m/yy convert to m/d/yy. How do I prevent this
from happening
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindy...r/MergFram.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"GayleT" wrote in message
...
When I use an excel spreadsheet as a data source for a word mail merge my
dates that are formatted d/m/yy convert to m/d/yy. How do I prevent this
from happening



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
Cells formatted to % but in mail merge they are showing as decima. Jerry Ray Microsoft Word Help 3 January 8th 05 03:47 PM
How do I convert a PDF file to word for a mail merge? Kevin B Microsoft Word Help 2 December 23rd 04 04:27 AM
How do I send a mail merge email with an excel attachment%3f Geri Tables 1 December 3rd 04 01:51 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 01:31 PM
How do you set up a label mail merge with Excel as source in 2003. Psychic Mom Mailmerge 1 November 27th 04 03:03 PM


All times are GMT +1. The time now is 11:39 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"