How do you convert cells to date in Excel?

  1. Select the cells and click Kutools > Content > Convert to Date. See screenshot: Then you can see all selected cells have been converted to standard date format. In fact, if you have Kutools for Excel, you can use its Split Cells and Combine utilities to convert dd.mm.yyyy to dd/mm/yyyy.
    For More Information Please Refer:
    https://www.extendoffice.com/documents/excel/3784-excel-convert-dd-mm-yyyy-to-date-format-dd-mm-yyyy.html
    You May Also Like to Read:
    How do I set a time zone in Java?