Trouble with using excell as a data base in Word mail merge.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stumped at work - 31 May 2006 15:05 GMT

When I am using an Excell worksheet as my data source in Word mail merge,
some of my values do not show up like I want them to. The main problems being
dates, currency and numbers. For example, one of my columns consist of
numbers with two decimal points and the 1000 separator (,) but when I bring
it up as my data source in word, the numbers only have one decimal point and
the separator is not there. How can I stop this from happening?

Reply to this Message

Graham Mayor - 31 May 2006 15:58 GMT

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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When I am using an Excell worksheet as my data source in Word mail
> merge, some of my values do not show up like I want them to. The main
[quoted text clipped - 3 lines]
> numbers only have one decimal point and the separator is not there.
> How can I stop this from happening?

Reply to this Message