Formatting as Currency in a Merge Field

[Debra]

I am merge a Word Document with an Excel Spreadsheet.
Some of the columns are formatted as currency. When I
merge them into Word, the $ and .00 disappear. When I
looked up the Switches, it says to add \#. I tried to add
it everywhere but it doesn't seem to work. Could you
please tell me where I would add it in the following merge
code:

{MERGEFIELD "LifeBenefitOption"}

Thanks,

Deb

 

[Peter Jamieson]

\# on its own isn't enough (just in case that is what you tried!

Try

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