Word field formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryck J - 22 Jun 2004 22:37 GMT

I am trying to create a mailmerge doc with the data coming from Excel. I have a "skip record if data field is blank" field that draws from the excel sheet. The Excel field is a formula that reads if(w2>w3,w2,""). In the spreadsheet, it comes up blank, but Word reads it as "0". How can I fix this?

Reply to this Message

Doug Robbins - Word MVP - 23 Jun 2004 10:31 GMT

Toggle on the field codes using Alt+F9 and add the following formatting
switch inside the closing }

\# "#; ;"

Replace the # inside the quotes with however you want the number to be
formatted, add a formatting picture of negative numbers if required between
the semi-colons.

It's not having anything after the last semi-colon that controls the display
of a zero value.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am trying to create a mailmerge doc with the data coming from Excel. I have a "skip record if data field is blank" field that draws from the excel

sheet. The Excel field is a formula that reads if(w2>w3,w2,""). In the
spreadsheet, it comes up blank, but Word reads it as "0". How can I fix
this?

Reply to this Message