reading data inaccurately when merging from Excel to Word

I am trying to merge from Excel into Word. One of the columns contains date
format data which is generated by a forumal. The same column also contains
some records which return "N/A" and is in text format, manually imputted.

The merge instruction within Word is:

MERGEFIELD First_Board_T \@"YY"

However this will not recognise "N/A" and merges this entry as a date.

How can I tell word to migrate the exact data contained within the column?

Grateful for your assistance.

Loz

You will need a conditional field
{IF {MERGEFIELD First_Board_T} "N/A" "{MERGEFIELD First_Board_T \@
"YY"}" "N/A"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Loz wrote:
I am trying to merge from Excel into Word. One of the columns
contains date format data which is generated by a forumal. The same
column also contains some records which return "N/A" and is in text
format, manually imputted.

The merge instruction within Word is:

MERGEFIELD First_Board_T \@"YY"

However this will not recognise "N/A" and merges this entry as a date.

How can I tell word to migrate the exact data contained within the
column?

Grateful for your assistance.

Loz