I have this field in my mail merge document:


{MERGEFIELD "UNIT"}


It merges data from the data source (Excel Worksheet) from a column headed UNIT.


The UNIT column contains predominently numbers, but there are a few text values as well, "LOWER", "UPPER", "AF-1" for example.


When the merge is completed (and in preview as well), the new document shows those records with a value of "0" instead of the textual value in the cell of the database (ie LOWER, AF-1 etc).


The records that aren't textual, ie values in the UNIT column equal to 1, 2, 3, 4 5 etc all display in the merged document fine. It just seems to be the text values.


Any idea what might be causing this behaviour?