Date/Time format problem merging EXCEL or Access info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 30 Jul 2003 19:15 GMT

Word 2002, EXCEL 2002 and Access 2002 problem: When I
merge an EXCEL table or an Access table to a Word
document, the date and time formats on the source date are
not carried into the merged Word document. I need to have
July 30, 2003 (in either table) repeated in my doc, not
7/30/2003.
Any suggestions? Thanks...

Reply to this Message

Peter Jamieson - 30 Jul 2003 23:08 GMT

Use date format switches within the Word fields, e.g. instead of

{ MERGEFIELD mydate }

use

{ MERGEFIELD mydate \@"MMMM D, YYYY" }

The switches are documented in Word Help.

--
Peter Jamieson
MS Word MVP

> Word 2002, EXCEL 2002 and Access 2002 problem: When I
> merge an EXCEL table or an Access table to a Word
[quoted text clipped - 3 lines]
> 7/30/2003.
> Any suggestions? Thanks...

Reply to this Message