Rounding of currency issue.

[rflitn]

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!

 

[rflitn]

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

 

[Doug Robbins - Word MVP]

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.

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

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 [mergefield 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!

 

[Graham Mayor]

To get the unrounded dollar amount you need

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 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 [mergefield 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!