Hi Angie,
In your mailmerge main document:
. select the MERGEFIELD field that pulls in the value;
. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
. edit the field so that you get {MERGEFIELD MyData \# "$,0.00;($,0.00)"};
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.
Cheers
[MS MVP - Word]