How to Identify and Convert Date Format in Excel Office 365?
Tags: convertdateformatine, kutoolsexceltutorial, kutools
Published: 2020-11-18 12:00:20

---
title: How to Identify and Convert Date Format in Excel Office 365?
published: true
date: 2020-11-18 09:22:39 UTC
tags: ConvertDateFormatinE,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-28.png)<figcaption id="caption-attachment-17577">Select the range</figcaption>

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

![Select the Convert to Date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-to-Date-option.png)<figcaption id="caption-attachment-17574">Select the Convert to Date option</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-27.png)<figcaption id="caption-attachment-17578">Convert to Date dialog box</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-27.png)<figcaption id="caption-attachment-17579">Output</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-23.png)<figcaption id="caption-attachment-17580">Input range</figcaption>

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

![Select the Convert to Date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-to-Date-option.png)<figcaption id="caption-attachment-17574">Select the Convert to Date option</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-19.png)<figcaption id="caption-attachment-17581">Convert to Date Dialog Box</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-18.png)<figcaption id="caption-attachment-17582">Output</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-16.png)<figcaption id="caption-attachment-17583">Input Range</figcaption>

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

![Select the Convert to Date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-to-Date-option.png)<figcaption id="caption-attachment-17574">Select the Convert to Date option</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-16.png)<figcaption id="caption-attachment-17584">Convert to Date Dialog Box</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-13.png)<figcaption id="caption-attachment-17585">Output</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-12.png)<figcaption id="caption-attachment-17586">Select the range</figcaption>

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

![Select the Convert to Date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-to-Date-option.png)<figcaption id="caption-attachment-17574">Select the Convert to Date option</figcaption>

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

![Click the Close button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-8.png)<figcaption id="caption-attachment-17587">Click the Close button</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-8.png)<figcaption id="caption-attachment-17588">Output</figcaption>

## 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.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Extract URL Links From Hyperlinks or To Convert Plain Text Links to Hyperlinks in Excel!!](https://geekexcel.com/wp-admin/post.php?post=17316&action=edit)
- [Split Data Into Multiple Worksheets Based On Selected Column in Excel!!](https://geekexcel.com/wp-admin/post.php?post=17282&action=edit)