Add a formatting switch to the Formula
\# "$,0.00;;"
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
"Bob" wrote in message
...
On an ivoice template with multiple lines, I want to hide all zero
results.
Ie if the invoice template has 5 lines but the invoice only has 2 items i
want to hide the 0.00 results.
If (qty shipped =0) then show"" otherwise show (qty*price)