Change date automatic in an excel column

Thank you, but I already know that. Or actually it workes not if I past as a value, but as a special and then I cklick "add".
But what I want is the format to change automatic even if I copy paste in the normal way.
Because I also copy a lot of text cells in the same time as the dates.