View Single Post
  #1   Report Post  
Frustrated in Oz
 
Posts: n/a
Default Date format in Non- American?

Word document which has info from Excel Merged to it.
Dates which have been merged into the the document are appearting in mixed
formats.
Past game dates are coming up in British format ie 24 November 2004
Future game dates are coming up American style ie 1 May 2005 instead of 5
January 2005. Using Shift F9 both field switches are the same ie
MERGEFIELD "Next_Date" \@ "d MMMM yyyy"
MERGEFIELD "Last_Date" \@ "d MMMM yyyy"
Source Excel Doc has the dates as 24/11/04 & 5/1/05 with the format set as
d-mmm-yy.
Thanks.