Sat 20 Oct 11:00 AM > Sun 20 Oct 11:00 AM ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JethroUK© - 13 Oct 2007 01:48 GMT

I have a date/time field in excel formatted as:

Sat 20 Oct 11:00 AM

After merging to word with no formatting options it reads:

Sun 20 Oct 11:00 AM

?????

Reply to this Message

JoAnn Paules - 13 Oct 2007 02:13 GMT

Are you sure it's looking at the correct year?

Signature

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

>I have a date/time field in excel formatted as:
>
[quoted text clipped - 5 lines]
>
> ?????

Reply to this Message

JethroUK© - 13 Oct 2007 10:55 GMT

I have now included the year:

Sat 20/Oct/2007 11:00 AM

And it is merged as:

Sun 20/Oct/2007 11:00 AM

?

Im in UK (probably the problem) Vista HP on my ol Office 2002

> Are you sure it's looking at the correct year?
>
[quoted text clipped - 7 lines]
>>
>> ?????

Reply to this Message

Graham Mayor - 13 Oct 2007 11:57 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.

This should also fix your later problem.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have now included the year:
>
[quoted text clipped - 27 lines]
>>>
>>> ?????

Reply to this Message

Strange phenomena but that's cured it thanks

> From the Tools menu in Word, select Options and then go to the General tab
> and check the box against the "Confirm conversions at open" item. Then
[quoted text clipped - 35 lines]
>>>>
>>>> ?????

Reply to this Message