Date Format from Excel Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smudge - 06 Mar 2007 14:44 GMT

Hi all,

Sorry about the subject line

I'm using mail-merge to produce daily signing in sheets. Mail merge fields
are just day of the week and date. Start date can be entered on an excel
sheet and subsequent days and dates fill in using a formula.

My problem is that even though I've changed the format to custom ddmmyy (or
something like that) it's displaying in the merge field as 03/06/2007.

Any ideas please?

Signature

Smudge

Reply to this Message

Doug Robbins - Word MVP - 06 Mar 2007 21:12 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

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

> Hi all,
>
[quoted text clipped - 9 lines]
>
> Any ideas please?

Reply to this Message

Smudge - 07 Mar 2007 17:28 GMT

Many thanks it worked a treat!

Signature

Smudge

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 14 lines]
> >
> > Any ideas please?

Reply to this Message

Rate this thread: