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 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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

arrow blue right bubbleClick Kutools >> Content Converter >> Convert to Date. See screenshots:

shot-convert-date-format1


arrow blue right bubbleUsage:

1. Select the range that you want to apply this utility.

2. Then apply the utility by clicking Kutools > Content convert > Convert to Date. See screenshots:

shot-convert-date-format2arrow-bigshot-convert-date-format3

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.


arrow blue right bubbleConvert 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.

shot-convert-date-format4pngarrow-bigshot-convert-date-format5

arrow blue right bubbleConvert 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.

shot-convert-date-format6arrow-bigshot-convert-date-format7

arrow blue right bubbleConvert long date formats into local short date formats

shot-convert-date-format8arrow-bigshot-convert-date-format9

arrow blue right bubbleConvert non-standard date formats into local date formats

shot-convert-date-format10arrow-bigshot-convert-date-format11

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 120 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase