mailmerging question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ap2sweet - 28 Dec 2004 16:13 GMT

how do i add decimals, i.e. zeros, to numbers i mailmerge in word from excel
spreadsheets.

for example on excel i have the # $700.00
but when i mail merge the data into a word template
i get $700

so i don't get the .00

how do i solve this problem?

Reply to this Message

S Stone - 30 Dec 2004 00:43 GMT

How do you have the excel cell/column formated. I tryed both currency as
well as accounting formats and both carried over.

S. Stone

> how do i add decimals, i.e. zeros, to numbers i mailmerge in word from excel
> spreadsheets.
[quoted text clipped - 6 lines]
>
> how do i solve this problem?

Reply to this Message

Graham Mayor - 30 Dec 2004 07:59 GMT

Whether or not the formatting will carry will be determined by the Word
version and how it is connnected to the data file. With Word 2002/3, the
default is for Word to provide the formatting.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do you have the excel cell/column formated. I tryed both
> currency as well as accounting formats and both carried over.
[quoted text clipped - 11 lines]
>>
>> how do i solve this problem?

Reply to this Message

Rate this thread: