[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

"rflitn" wrote in message
ups.com...
I neglected the fact that the data is being brought in from an Excel
spreadsheet.

rflitn wrote:
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!