"0" from Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Caldwell - 07 Sep 2005 01:19 GMT

Hello

I'm having problems configuring my mergefields to report a blank as opposed
to a "0" from an empty MSExcel field. These are text fields, but I can't
figure out how to set up the IF..THEN test. Any help would be appreciated.

Thank you

Jeff

Reply to this Message

Doug Robbins - 07 Sep 2005 04:54 GMT

{ IF { MERGEFIELD fieldname } <> "" "{ MERGEFIELD fieldname } "" }

using Ctrl+F9 to insert the field delimiters { }and Alt+F9 to toggle of the
display of the field codes.

Signature

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

> Hello
>
[quoted text clipped - 8 lines]
>
> Jeff

Reply to this Message