Hi,
Format the dates to dd/mm/yyyy

Highlight the dates

Format > Cells > Number tab > Date > choose the one you need

If it is not in there go to Custom and put dd/mm/yyyy in the space provided under Type.

HTH.