Zeros in blank fields

I'm using Office XP and creating mailing labels using and
Excel database. Some fields in the label may be empty in
the database. Excel is printing "0" in those locations
instead of leaving them blank. This didn't happen with
the same form and data using Word in Office 2000. Any
suggestions for what I'm doing wrong. Tried {MERGEFIELD
[data]\F" "}. That results in 0 followed by contents
of " ".

Try
{IF {Mergefield [data]} "0" "{Mergefield [data]}"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




William Peters wrote:
I'm using Office XP and creating mailing labels using and
Excel database. Some fields in the label may be empty in
the database. Excel is printing "0" in those locations
instead of leaving them blank. This didn't happen with
the same form and data using Word in Office 2000. Any
suggestions for what I'm doing wrong. Tried {MERGEFIELD
[data]\F" "}. That results in 0 followed by contents
of " ".

Thanks for the reply and I'll try it. I'll also check your web site.

"Graham Mayor" wrote:

Try
{IF {Mergefield [data]} "0" "{Mergefield [data]}"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




William Peters wrote:
I'm using Office XP and creating mailing labels using and
Excel database. Some fields in the label may be empty in
the database. Excel is printing "0" in those locations
instead of leaving them blank. This didn't happen with
the same form and data using Word in Office 2000. Any
suggestions for what I'm doing wrong. Tried {MERGEFIELD
[data]\F" "}. That results in 0 followed by contents
of " ".