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