Have changed the date format and it's working correctly. We just had to add the extra step of copying into a new workbook and using paste spepical | valuses.