Merge Problems with empty fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

itdeptgeu@hotmail.com - 29 Oct 2004 00:53 GMT

I have an excel data source. some fields are empty, some have numbers.
column is formatted for text only. when I merge the into word main document,
the empty field now has a value of zero (0). this only happens on some
columns, but not all even though they are formatted same. Have tried
stripping to text only into word, reimporting back into excel, changing
fonts, etc. nothing works. anyone else having same problems or have
solutions. tks

Reply to this Message

Doug Robbins - 29 Oct 2004 11:11 GMT

Add the following formatting switch to the mergefields in Word inside the
closing } after you toggle on the display of field codes with Alt+F9

\# "#;-#;"

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have an excel data source. some fields are empty, some have numbers.
> column is formatted for text only. when I merge the into word main
[quoted text clipped - 4 lines]
> fonts, etc. nothing works. anyone else having same problems or have
> solutions. tks

Reply to this Message