How to hide zeroes in Mail merge document?,
Use an If...then...Else field construction
{ IF { MERGEFIELD nameoffieldthatmightbezero } = 0 "" "{ MERGEFIELD
nameoffieldthatmightbezero }" }
You must use Ctrl+F9 to insert each pair of field delimiters { } and you use
Alt+F9 to toggle off their display
--
Hope this helps
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.
"Rao" wrote in message
...
The source is excel document and zeroes are hidden but in mail merge they
appear as zeroes!!
|