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