Date format Change during Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fresnotony - 01 Dec 2003 20:06 GMT

I'm trying to create a catalog using the mail merge function in Word form Excel

Example: In Excel the date display as 4/5 after the merge is displays at 4/5/0

If it were only one or two records I'd just go through and change them by hand, but I can't change 2,000 dates
Is there a way to keep the format of the date the same after the merge
mm/yy --> mm/yy NOT mm/yy --> dd/mm/yy

Thanks

Reply to this Message

Peter Jamieson - 02 Dec 2003 13:46 GMT

I'd guess you are using Word 2002 or 2003, in which case try checking Word
Tools|Options|General|"Confirm conversions at open", go through the
connection process again and select the "Excel via DDE" option when offered.

--
Peter Jamieson - Word MVP

> I'm trying to create a catalog using the mail merge function in Word form Excel.
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

fresnotony - 04 Dec 2003 03:26 GMT

Thank you SOOOOO much.

it worked perfectly.

-FresnoTony

----- Peter Jamieson wrote: -----

I'd guess you are using Word 2002 or 2003, in which case try checking Word
Tools|Options|General|"Confirm conversions at open", go through the
connection process again and select the "Excel via DDE" option when offered.

--
Peter Jamieson - Word MVP

"fresnotony" <fresno(**no spam**)tony@hotmail.com> wrote in message
news:9B983489-5954-4406-832E-5FE4660B7D93@microsoft.com...
> I'm trying to create a catalog using the mail merge function in Word form
Excel.
>> Example: In Excel the date display as 4/5 after the merge is displays at
4/5/04
>> If it were only one or two records I'd just go through and change them by
hand, but I can't change 2,000 dates.
> Is there a way to keep the format of the date the same after the merge?
> mm/yy --> mm/yy NOT mm/yy --> dd/mm/yy
>> Thanks

Reply to this Message