[Rao]

The source is excel document and zeroes are hidden but in mail merge they
appear as zeroes!!

[Doug Robbins - Word MVP]

Use an If...then...Else field construction

{ IF { MERGEFIELD nameoffieldthatmightbezero } = 0 "" "{ MERGEFIELD
nameoffieldthatmightbezero }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and you use
Alt+F9 to toggle off their display

--
Hope this helps

Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to avail yourself of my
services on a paid, professional basis.

"Rao" wrote in message
...
The source is excel document and zeroes are hidden but in mail merge they
appear as zeroes!!

[macropod[_2_]]

Hi Rao,

You don't need Doug's complicated field construction (actually, it's not really that complicated). You can do it with a simple
formatting switch.

To control number & currency formatting with a numeric picture switch:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.


--
Cheers
macropod
[Microsoft MVP - Word]


"Rao" wrote in message ...
The source is excel document and zeroes are hidden but in mail merge they
appear as zeroes!!

[Doug Robbins - Word MVP]

Hi Paul,

It took a long time to get to the ;

For a while there, I thought that you had glossed over it altogether. G

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"macropod" wrote in message
...
Hi Rao,

You don't need Doug's complicated field construction (actually, it's not
really that complicated). You can do it with a simple formatting switch.

To control number & currency formatting with a numeric picture switch:
. select the field;
. press Shift-F9 to reveal the field coding. It should look something like
{MERGEFIELD MyData};
. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or
whatever other numeric format you prefer - see below);
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Note: The '\# $,0.00' in the field is referred to as a numeric picture
switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands
separator
. \# $,0 for rounded whole dollars with a thousands separator
. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative
numbers and a hyphen for 0 values


The precision of the displayed value is controlled by the '0.00'. You can
use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following,
(eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this
suppresses 0s resulting from empty fields and from fields containing 0s.


--
Cheers
macropod
[Microsoft MVP - Word]


"Rao" wrote in message
...
The source is excel document and zeroes are hidden but in mail merge they
appear as zeroes!!