How to convert a number in time with Excel ?

When we enter a date with points, is there a possibility to convert it automatically into a date with slashes, so that it could be taken into consideration as a date ?

There is two solution, with a formula like this :

=SUBSTITUE(C2;".";"/")

Or select the celles containing the date to modify, Menu > Home > Search and select > replace . by /