[Earl]

I have two columns with dates in excel as mm/dd/yy, formatted the same, as
text.

Both are linked to the same word document and have the date format switches
to month day, 20XX.

Conditional formatting is set-up for the sheet to alternate shading of rows.

The secondary column displays the date but not text 'n/a' or anyother text.

The primary column always has a date, but a test since this problem shows it
will display text also.

This problem started with the use of Office 2007.

Thanks in advance