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??
|