Excel function about Date

Question

i want to know the function to get .01.09.2016 from 1/9/2016 in excel.I applied this function "=DATE(LEFT(A1,4),MID(A1,4,20),RIGHT(A1,2))" but this gives result 17.08.4243 from 09/01/2016 and also customized these two cells as dd/mm/yyyy and dd.mm.yyyy.

Answer 1

Try the TEXT function

    =TEXT(A1,"dd.mm.yyyy")