[Alex Hammerstein]

Many thanks - worked a treat

A



On 03/02/2009 11:13, in article ,
"macropod" wrote:

Hi Alex,

In Word:
. select the field;

. press Ctrl-F9 to reveal the field coding. It should look something like
{MERGEFIELD MyData};

. edit the field so that you get {MERGEFIELD MyData \# 0};

. position the cursor anywhere in this field and press F9 to update it;

. run your mailmerge.


Note: the precision of the displayed value is controilled by the '0.00'. You
can use anything from '0' to '0.000000000000000'.

If you add a final ';' to the formatting switch (eg \# 0;-0 zero values will
be suppressed. This suppresses 0s resulting from
empty fields and from fields containing 0s.