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
Bookmarks