Excel Date and Time not merging correctly to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Heather Fabries - 20 Dec 2007 12:19 GMT

I am using an excel spreadsheet to merge date and time to a Word letter. The
date format is set up in excel as Thursday, December 20, 2007 and the time as
7:15 AM. I did this through 'Format Cells". However, when I pull it over to
Word through the mail merge, it is showing the date that is seen in the
format bar - 12/19/2007 and the time 7:15:00 AM. How do I get it to pull
over the value in the cell and not what is in the formula bar?

I tried this in both Excel and Word 2003 and 2007.

Thank you.
Heather Fabries

Reply to this Message

Big Mac - 20 Dec 2007 14:08 GMT

Right click on the field in word and Edit the field code to look something
like
{ "MERGEFIELD "YourDateFieldName" \@"dd,MM,yyyy"} be careful to use caps
where necessary

Signature

Hope this helps :-)

> I am using an excel spreadsheet to merge date and time to a Word letter. The
> date format is set up in excel as Thursday, December 20, 2007 and the time as
[quoted text clipped - 7 lines]
> Thank you.
> Heather Fabries

Reply to this Message

Graham Mayor - 20 Dec 2007 14:08 GMT

Word imports the raw data. You have to use a formatting switch to format it
as required.

In the case of the date
{Mergefield Datefieldname \@ "dddd, MMMM d, yyyy" }

in the case of the time
{Mergefield TimeFieldName \@ "hh:mm AM/PM" }

Press ALT+F9 to toggle the display and add the switches to the fields.

See http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> I am using an excel spreadsheet to merge date and time to a Word
> letter. The date format is set up in excel as Thursday, December 20,
[quoted text clipped - 8 lines]
> Thank you.
> Heather Fabries

Reply to this Message