I am doing a mail merge from Word to Excel. I am using
clean generic formatted numbers with 2 decimal places in
the original data source (And have even tried it with the
currency being formatted as text).
I close this and go to my Word and start the merge
process off of a blank document. When I preview my
document (which only contains two merge codes and no
other text or formatting then what is in my default
normal.dot, it extends my decimal place in my currency
field when I preview it.
Why is it doing this to my currency field. I am not
adding in any more that a 2 decimal place number in my
data source and I still get this even when that column
has been formatted to recognize this number as text. I
am at a loss. What can I do to fix this?
You got me.@ the IT Help Desk
Graham Mayor - 08 Aug 2003 08:55 GMT
This is caused by the way Word now connects to Excel
See the relevant section at
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm
and http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm for an
alternative workaround

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
> I am doing a mail merge from Word to Excel. I am using
> clean generic formatted numbers with 2 decimal places in
[quoted text clipped - 15 lines]
>
> You got me.@ the IT Help Desk