Quickly identify and convert date format in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
In Excel, you may need to convert the dates stored as text into date formats or identify various non-standard dates as the locale date formats according to your operating system settings. Kutools for Excel’s Convert to Date can help you quickly apply following operations in Excel.
Convert dates stored as text into the local date formats
Convert date formats into the local date formats
Convert long date formats into local short date formats
Convert non-standard date formats into local date formats
Click Kutools > Content > Convert to Date. See screenshot:
Usage:
1. Select the range that you want to apply this utility.
2. Then apply the utility by clicking Kutools > Content > Convert to Date. See screenshots:
 |  |  |
3. All of the dates stored as text or non-standard date formats will be converted to your local date formats.
Note: If you don’t want to convert some specified dates in the range, please hold down CTRL key to select or highlight them in the Convert To Date dialog box, and then click Recover button to stay unchanged them.
Convert dates stored as text into the local date formats
Supposing you have a range of dates stored as text in your workbook, you can apply Convert To Date to convert them into date formats.
 | |  |
Convert date formats into the local date formats
This utility can also convert various date formats into your local date formats according to your operations system settings.
 | |  |
Convert long date formats into local short date formats
 | |  |
Convert non-standard date formats into local date formats
 | |  |
Demo: identify and convert date format in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
