Thanks Doug. i had a look at the information on the website that you
directed me to. Unfortunately, it meant nothing to me. I was hoping for a
simple solution!
I thought that if I could delete the English (US) from the language box,
leaving only English (Australia) it may help. But I don't know how to do
that.
I have performed the same mail merge in the past without this problem, so I
don't know why it's appearing now.
Maybe, I'll have to type the dates (in Excel) in text format!
Cheers. Travers
"Doug Robbins - Word MVP" wrote:
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" section of fellow MVP Cindy
Meister's website at:
http://homepage.swissonline.ch/cindy...r/MergFram.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
"TP" (donotspam) wrote in message
news
When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003
document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009
merges as 03-18-2009. Both the Excel and Word programs have their
language
set at English (Australia), although the Word Language box has both
English
(Australia) and English (US) listed, with English (Australia) set as the
default.
Does anyone have any ideas on how I can get the date to show in the
correct
format, dd-mm-yyyy?
Cheers. Travers