Zeros in blank fields

[William Peters]

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 " ".

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[wpeters]

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

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 " ".

 

[Guest]

That doesn't seem to work here. I tried to manually
enter other fields using ^F9 and manually entering the
code and that works with no problem. If I use the
statement below, after applying the database then
checking the code by toggling fieldcodes, part of the
code is missing and the "0" shows up in the code and on
the form in place of a field name. I've tried all sorts
of configurations of this and it will not work. Either
I'm going nuts in my old age or there is something
definitely wrong with the way Word XP handles this stuff.

BTW - Nice new home and great pictures. I retired to San
Diego and am doing remodel work but not a new home.
Thirty three years at Xerox wore me out!

-----Original Message-----
Try
{IF {Mergefield [data]} <> "0" "{Mergefield [data]}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 " ".

.

 

[Graham Mayor]

Difficult to advise on this. You could change the method of connecting to
the data as illustrated in the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm, but if the empty
field produces 0 then trapping that in the manner suggested should work.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

That doesn't seem to work here. I tried to manually
enter other fields using ^F9 and manually entering the
code and that works with no problem. If I use the
statement below, after applying the database then
checking the code by toggling fieldcodes, part of the
code is missing and the "0" shows up in the code and on
the form in place of a field name. I've tried all sorts
of configurations of this and it will not work. Either
I'm going nuts in my old age or there is something
definitely wrong with the way Word XP handles this stuff.

BTW - Nice new home and great pictures. I retired to San
Diego and am doing remodel work but not a new home.
Thirty three years at Xerox wore me out!

-----Original Message-----
Try
{IF {Mergefield [data]} <> "0" "{Mergefield [data]}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 " ".

.