In the Mail Merge main document, press Alt+F9 to toggle on the display of
the field codes and go to the field that contains the currency amount and
you will see
{ MERGEFIELD [fieldname] }
where [fieldname] is the name of the field in your data source.
Inside the closing }, insert the following switch
\# "$,0.00"
or if you have negative amounts that you want to place in parentheses,
use
\# "$,0.00;($,0.00)"
so that you have
{ MERGEFIELD [fieldname] \# "$,0.00" }
or
{ MERGEFIELD [fieldname] \# "$,0.00;($,0.00)" }
Use Alt+F9 again to toggle off the display of the field codes and then
execute your merge.
--
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, originally posted via msnews.microsoft.com
Doug Robbins - Word MVP said:
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at :
http://www.gmayor.com/formatting_word_fields.htm
--
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, originally posted via msnews.microsoft.com
message
I am merging quite a bit of data and the fields that have currency are
not
formatting correctly. The merge takes place inside a table cell and
some
format without the dollar sign. I have changed the formatting to
number
with
two decimal places and when I merge I get lots of zeroes after the
decimal
ending in 3. What am I doing wrong????? This is driving me crazy!