View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default format zero values merge fields

There are various possible ways you could deal with this depending on what
you want to see when the number is positive or negative, but, e.g.

{ MERGEFIELD myfield \#"'{ MERGEFIELD myfield }';'{ MERGEFIELD
myfield }';'-'" }

where all the {} are the special field braces you can insert using ctrl-F9

Peter Jamieson
"am" wrote in message
...
I am using Word and Excel 2007 and am mail merging numeric values from
Excel
into Word. I would like any zero values to be returned as "-." I know
how
to return the values as "0" or blank, but not as "-". Does anyone know
the
"switch" that gets me to this format??