The issue isn't empty cells. I'm running test trials and some cells in my word document are coming out as dates. Others as the 5 digit number that excel see's dates as. I can't find any differences to the ones that are working and the ones coming out as the series of 5 numbers. This problem is driving me crazy. It should be so simple yet just wont work. When it does work its simple to change the date format. Just can't seem to get a date to appear on word.