To get the unrounded dollar amount you need
{ =INT({ Mergefield box_a }) \# ",0;;" }
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
rflitn wrote:
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!