|It is not an Excel issue.|
I believe what you need to do is change the System Date Format,
it is probably set for US and you need to change to UK.
Look here for instructions on changing the System Date:
This is for Win 7, but Win 10 should be similar.
message edited by mmcconaghy