dates and currency

[Gwyn]

When completing a mail merge using office xp the
formatting of dates and currency from the excel
spreadsheet does not transfer onto the word document.
Can someone help please.

 

[Andrew]

You need to do it as a DDE link. I think it defaults as
OLE and the formatiing does not come up. Have a look at
this

Microsoft Knowledge Base Article - 320473

WD2002: Excel Data Does Not Retain Its Formatting in Mail
Merge Operations

I have the same problem but the Select Data Source as
mentioned in the article does not appear when I select the
XLS. I am trying to find out why not.

 

[Graham Mayor]

See the Excel data section of
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm
or (if you use US date patterns in Australia) use a switch on the mergefield
to set the required data pattern.
This does not work well with UK date patterns.
See http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>