Currency format (2003 sp2)

[chuckrau]

I have a merge document whose data source is a spreadsheet. The dollar amounts are formatted currency in the sheet, (actually it's a custom currency format). When I merge the document I get straight numbers. How can I format the field for currency?

[chuckrau]

That worked beautifully. Thank you Hans.

I never would have figured that out from the help file.

[HansV]

Right-click the merge field.
Select Toggle Field Codes from the popup menu.
You'll see something like
<code>{ MERGEFIELD Amount }</code>
or
<code>{ MERGEFIELD Amount * MERGEFORMAT }</code>
Make it look like
<code>{ MERGEFIELD Amount # "$#,##0.00#" }</code>
or
<code>{ MERGEFIELD Amount # "$#,##0.00#" * MERGEFORMAT }</code>
Press F9 to hide the field code and update the result.