View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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!!