Rounding of currency issue.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rflitn - 15 Aug 2006 19:30 GMT

I have created a mail merge in Word that brings in currency. I need to
populate the dollar and cents in two separate fields, basically taking
the currency entry in the excel spreadsheet (ie: 100.55) and parse it
to 100 and .55.

I've accomplished this with the proper field :
mergefield box_a [mergefield box_a\#"0;;"]
and
mergefield box_a [emrgefield box_a\#".00;;"]

However, it rounds the dollar amount (ie: 100.55 would come up as 101
and .55).

I need to prevent the rounding, keeping it accurate. Is there either an
addition to the above or a better method? Thanks in advance!

Reply to this Message

rflitn - 15 Aug 2006 19:32 GMT

I neglected the fact that the data is being brought in from an Excel
spreadsheet.

> I have created a mail merge in Word that brings in currency. I need to
> populate the dollar and cents in two separate fields, basically taking
[quoted text clipped - 11 lines]
> I need to prevent the rounding, keeping it accurate. Is there either an
> addition to the above or a better method? Thanks in advance!

Reply to this Message

Doug Robbins - Word MVP - 15 Aug 2006 20:00 GMT

Well, the best thing is probably to add a couple of columns to the Excel
spreadsheet and use Excel superior ability to get what you want.

Alternatively in Word, you can probably do

{ = ({ MERGEFIELD mergefield box_a \# "0,00;;" } - { MERGEFIELD mergefield
box_a \# ".00;;" }) \# "0;;" }

for the dollar amount.

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 neglected the fact that the data is being brought in from an Excel
> spreadsheet.
[quoted text clipped - 14 lines]
>> I need to prevent the rounding, keeping it accurate. Is there either an
>> addition to the above or a better method? Thanks in advance!

Reply to this Message

Graham Mayor - 16 Aug 2006 06:05 GMT

To get the unrounded dollar amount you need

{ =INT({ Mergefield box_a }) \# ",0;;" }

Signature

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

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

> I neglected the fact that the data is being brought in from an Excel
> spreadsheet.
[quoted text clipped - 14 lines]
>> I need to prevent the rounding, keeping it accurate. Is there either
>> an addition to the above or a better method? Thanks in advance!

Reply to this Message