Hi Paul,

I'm afraid all that was way beyond my small brain.

The cell in the excel file is formatted as a date.

The date is entered as follows: 17/5/14 which displays as 17 May 2014

This still only displays as the 5 digit number in the Word document.

Cheers,

Andy