How to Identify and Convert Date Format in Excel Office 365?

In this tutorial, we will guide you to know the simple steps to Identify and Convert Date Format in Excel Office 365 with Kutools. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Convert Dates Stored as Text into the Local Date Formats:

To convert the dates stored as text into the local date formats, do as below steps.

• You need to select the range that you want to convert.

Select the range

• Then, on the Kutools Tab, select the Content option, choose the Convert to Date option.

Select the Convert to Date option

• It will open the Convert to Date dialog box.
• You need to click the Close button to close this dialog box.

Convert to Date dialog box

• Now, all the dates in the text formats will convert to the local date formats as shown in the below image.

Output

Steps to Convert Date Formats into the Local Date Formats:

To convert date formats into the local date formats, you need to follow the below steps.

• You need to select the range that you want to convert.

Input range

• On the Kutools Tab, select the Content option, choose the Convert to Date option.

Select the Convert to Date option

• It will display the Convert to Date Dialog Box , you need to click the Close button to see the result.

Convert to Date Dialog Box

• After that, it will convert the various date formats into the local date format as shown in the below screenshot.

Output

Convert Long Date Formats into Local Short Date Formats:

To change the long date formats into local short date formats, follow the below steps.

• First, you need to select the input range that you want to convert.

Input Range

• Go to the Kutools Tab, select the Content option, choose the Convert to Date option.

Select the Convert to Date option

• It will display the Convert to Date Dialog Box , you need to click the Close button to see the result.

Convert to Date Dialog Box

• Now, you can see that the long date formats are converted to the local short date formats as shown in the below example image.

Output

Steps to Convert Non-standard Date Formats into Local Date Formats:

If you want to convert non-standard date formats into a local date format, follow the below steps.

• You need to select the range that you want to convert.

Select the range

• Now, go to the Kutools Tab, select the Content option, choose the Convert to Date option.

Select the Convert to Date option

• It will display the Convert to Date Dialog Box , you need to click the Close button to see the result.

Click the Close button

• Finally, you will see that the non-standard date formats are converted into the local date formats as shown in the below figure.

Output

Verdict:

In this tutorial, we guided you to learn the steps to Identify and Convert Date Format in Excel Office 365 with Kutools. ** Give your **feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Keep Reading:

• Extract URL Links From Hyperlinks or To Convert Plain Text Links to Hyperlinks in Excel!!
• Split Data Into Multiple Worksheets Based On Selected Column in Excel!!