Excel formats don't merge correctly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin - 10 Dec 2003 14:44 GMT

I'm performing a mail merge using excel as a source
document. The numbers and dates are formatted correctly
in the excel document. For example, the date is spelled
out and numbers have commas. When the merge into word is
complete, the commas have been removed and the date format
is x/x/xxxx - which is not what is in the source
document. How can this be corrected?

Reply to this Message

Graham Mayor - 10 Dec 2003 14:53 GMT

Word 2002/3? - see the Excel data section at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm performing a mail merge using excel as a source
> document. The numbers and dates are formatted correctly
[quoted text clipped - 3 lines]
> is x/x/xxxx - which is not what is in the source
> document. How can this be corrected?

Reply to this Message