Make a new column in Excel, using an IF to discriminate between Not available (ISNA) and available, and FORMAT to format the date as you like to see it printed.
Then use this column in Word as a text field, not as a date field.
It's kind of a work-around, but quite workable.
Kees
I have been working with a database in MS Excel. Some of the columns include date information in the following format DD/MM/YY however some of the cells contain the text "N/A". I can not seem to migrate this text across on the merge as they are coming across as 01/04/05.
The Toggle for the merge is:
MERGEFIELD First_Board_T \@"YY"
How do it tell word that some of the data will be text as well as date formula?
Grateful for your assistance.
Loz

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic