Date format in Non- American?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frustrated in Oz - 02 Dec 2004 06:39 GMT

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.

Reply to this Message

Peter Jamieson - 02 Dec 2004 11:57 GMT

There's a problem in the OLEDB provider that Word 2002/2003 uses to get data
from Excel. You may be able to work around this by checking Word
Tools|Options|General|"Confirm conversions at open", going through the
connection process again and selecting the "Excel via DDE" option when
offered.

This problem may have been fixed in one of the Office Service Packs, and I
believe a patch is (or was) avaialble, but you'll probably have to contact
Microsoft Support directly to get it.

Peter Jamieson
--

> Word document which has info from Excel Merged to it.
> Dates which have been merged into the the document are appearting in mixed
[quoted text clipped - 8 lines]
> d-mmm-yy.
> Thanks.

Reply to this Message