Word/Excel 2002

H

HelenR128

When using an Excel spreadsheet as a data source for mail merge in Word, the
date format changes from dd/mm/yyyy to mm/dd/yyyy in the Word document. The
cells are formatted correctly and my regional settings in Control Panel are
OK.

I did not have this problem using previous versions of Office.
 
D

Doug Robbins

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/cindymeister/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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Formats 4
Forcing a date entry format of dd/mm/yyyy 1
Publisher is filling blank lines with data 2
Mail merge date from Excel 2003 to Word 2003 in same format 4
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
How do I get a Word mail merge to keep my access date format? 1
Merged Date Field Converting from Australian layout to American 2

Top