Just to add, this only happens on my user account, all other user
accounts are fine and you can enter the date as 16/11/07 and it comes
up as 16-Nov-07. It seems all settings on Excel have been changed to
US even though my regional settings are set to UK.