If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"0" from Excel Data
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 |
#2
|
|||
|
|||
"0" from Excel Data
{ 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. -- 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 "Jeff Caldwell" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Data from Excel to Access | Database Design | 2 | August 20th, 2004 12:53 PM | |
Merging Excel Data into Word Document | Debra Dalgleish | Worksheet Functions | 1 | February 16th, 2004 12:15 AM |