\# $#,##0.00 merge fields

[Guest]

when I merge from a table (the table is formatted to
Currency) I do not get currency fromat in letter.

Example <<Total Currency>> is the Field
How should it look to do complete the merge

I have tried <<Total Currency \# $#,##0.00>> and many
other combinations and it just doesn't work.

Can someone please show me how it should look.

 

[Peter Jamieson]

Before you try to insert the "format switch", use Alt-F9 to reveal the
underlying field codes. You may see something like

{ MERGEFIELD TotalCurrency } or

{ MERGEFIELD TotalCurrency \*Mergeformat }

Then insert the format switch. I would insert it as e.g.

{ MERGEFIELD TotalCurrency \#"$#,##0.00" }

You may find that

{ MERGEFIELD TotalCurrency \#"$,0.00" }

works as well as anything.