enter as what is allowed in your excel vesion. then hit "format cells" (under Home ribbon) and click "special" and in the window you type
d.m.y or any other form you like.
you can use text function
but under some cases it will be text and not manageable as date(number)
I prefer type
and format-special as above