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 to dd/mm/yyyy.
    For More Information Please Refer:
    You May Also Like to Read:
    How do I set a time zone in Java?