Excel to Word label merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erin.mcbride@sympatico.ca - 13 Apr 2004 16:39 GMT

I have a employee list with names and date of hire, the
hire dates in Excel appear as April 13, 2003 etc. When
merged they appear as a date 04/13/2003eg. I want the
text to appear DEcember ,April whatever, can you help

Reply to this Message

Graham Mayor - 13 Apr 2004 16:55 GMT

You need a switch on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm

In this case the switch would be \@ "MMMM d, YYYY"

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have a employee list with names and date of hire, the
> hire dates in Excel appear as April 13, 2003 etc. When
> merged they appear as a date 04/13/2003eg. I want the
> text to appear DEcember ,April whatever, can you help

Reply to this Message