Quickly identify and convert date format in Excel
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 Date Format Converter can help you quickly apply following operations in Excel.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Read more...
Classic Menu for Office: Bring Classic Menus and Toolbars of Office 2003/XP/2000 Back to Office 2007, 2010 and 2013. Read more...
Click Kutools >> Content Converter >> Date Format Converter. See screenshots:
1. Select the range that you want to apply this utility.
2. Then apply the utility by clicking Kutools > Content convert > Date Format Converter. 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 Date Format Converter dialog box, and then click Recover button to stay unchanged them.
Supposing you have a range of dates stored as text in your workbook, you can apply Date Format Converter to convert them into date formats.
This utility can also convert various date formats into your local date formats according to your operations system settings.