format zero values merge fields

[am]

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

 

[Peter Jamieson]

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