format zero values merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

am - 14 Mar 2007 19:57 GMT

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

Reply to this Message

Peter Jamieson - 14 Mar 2007 20:14 GMT

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

>I am using Word and Excel 2007 and am mail merging numeric values from
>Excel
[quoted text clipped - 3 lines]
> the
> "switch" that gets me to this format??

Reply to this Message

Rate this thread: