Question: how to change dd/mm/yy to dd/mm/yyyy in excel?
Answer: Convert dd/mm/yyyy to mm/dd/yyyy with Formulas Select a blank cell next to the dates you want to convert, type this formula =DATE(VALUE(RIGHT(A9,4)), VALUE(MID(A9,4,2)), VALUE(LEFT(A9,2))), and drag fill handle over the cells which need to use this formula.