Mailmerge and Decimals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TJAC - 05 May 2006 15:08 GMT

I have a Word 2002 document that includes a mail merge for labels from Excel.
I have two fields that include dollar amounts. The fields need to be
rounded to two decimal places. I inserted the additional formatting after
the field name as such: \#0.00x

That worked on one field, but it did not work on another field. What can I
do to the other field so it will be rounded as well.

Thanks!

Reply to this Message

Graham Mayor - 05 May 2006 15:33 GMT

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

> I have a Word 2002 document that includes a mail merge for labels
> from Excel. I have two fields that include dollar amounts. The
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

TJAC - 05 May 2006 17:12 GMT

Thank you for the link, but as far as I can tell I have tried the options
that are on the web page. I just don't understand why one of them will work
and the other one will not.

Thanks

> See http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 7 lines]
> >
> > Thanks!

Reply to this Message

Doug Robbins - Word MVP - 05 May 2006 19:00 GMT

Exactly what switch have you used? \#0.00x is definitely incorrect.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you for the link, but as far as I can tell I have tried the options
> that are on the web page. I just don't understand why one of them will
[quoted text clipped - 14 lines]
>> >
>> > Thanks!

Reply to this Message

TJAC - 05 May 2006 19:32 GMT

I have also tried \#"$,0.00;($,0.00)"

What should I be using because after I type in the above and press alt+F9,
nothing happens.

Thanks.

> Exactly what switch have you used? \#0.00x is definitely incorrect.
>
[quoted text clipped - 16 lines]
> >> >
> >> > Thanks!

Reply to this Message

Doug Robbins - Word MVP - 05 May 2006 21:47 GMT

And that is inside the closing } of the mailmerge field?

Have you then actually executed the merge?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have also tried \#"$,0.00;($,0.00)"
>
[quoted text clipped - 25 lines]
>> >> >
>> >> > Thanks!

Reply to this Message

TJAC - 05 May 2006 22:40 GMT

Yes, it is closed within the } I thought I executed it, but just to be sure
what should I do in order to execute the merge?

> And that is inside the closing } of the mailmerge field?
>
[quoted text clipped - 29 lines]
> >> >> >
> >> >> > Thanks!

Reply to this Message

macropod - 06 May 2006 00:39 GMT

Hi TJAC

> what should I do in order to execute the merge?

Run it like you normally would.

Toggling Alt-F9 doesn't update the field - it just toggles the field code
display on/off. Another way to see whether the field is formatting the
result correctly is to select 'view merged data' from the mailmerge toolbar.

Cheers

Reply to this Message