merging with blanks or adding $ symbols

[DKA]

I am attempting to merge a Word 2002 document with an excel spreadsheet that
contains some columns of numbers that I want to display with the dollar
symbol. I can add that field, however, if the field is blank, I don't want
the dollar symbol to print and the line to be skipped. How do I accomplish
this?

 

[Doug Robbins]

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