How to Change the Date Format in Excel Office 365? ~ Complete Guide!!
Tags: excelpreface, changedateformatinex, excelbasics, exceltutorials
Published: 2021-01-18 04:04:17

---
title: How to Change the Date Format in Excel Office 365? ~ Complete Guide!!
published: true
date: 2021-01-17 10:55:45 UTC
tags: ExcelPreface,ChangedateformatinEx,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/change-date-format-in-excel/
---

Usually, when you insert a date in a cell it is displayed in the format dd/mm/yyyy. There are many display formats such as long date, short date, etc… whatever the format you selected, the Excel preferred format in the formula bar will not change. Here, we come up with the quick steps to **change the date format in Excel**. 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)

## Steps to change the date format:

Now we are going to change the date format in Excel Sheet. Refer to the below example.

- First, we will give the input dates in [**Column**](https://geekexcel.com/excel-office-365-columns/)  **B** and select the **[cells](https://geekexcel.com/excel-cells-options/)** with dates.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-7.png)<figcaption id="caption-attachment-20953">Input Ranges</figcaption>

- Press the Right-click button, and it will display the dialog box.

![Right-Click options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Right-Clik-options-1.png)<figcaption id="caption-attachment-20954">Right-click options</figcaption>

- Here, we will select the **“[Format cell](https://geekexcel.com/shortcut-to-display-format-cells-with-font-tab-selected-in-ms-excel-365/)“** option.

![Format cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Format-cells.png)<figcaption id="caption-attachment-20955">Format cells</figcaption>

- In the “Format cells” window, you need to click the **“[Date](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)“** option from the left side list.

![Format cells Options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Format-cells-Options.png)<figcaption id="caption-attachment-20956">Format cells Options</figcaption>

- After that, it shows the date formats list on the right side.
- Here, you can select any date format as you wish then click the **“OK”** button.

![Select Date Format](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-Date-Format.png)<figcaption id="caption-attachment-20957">Select Date Format</figcaption>

- Now, the input dates will turn to the format that you selected.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-20.png)<figcaption id="caption-attachment-20958">Result</figcaption>

## Closure:

In this short tutorial, we have described the simple steps used to **change the date format in Excel**. Hope you like it. Mention your **queries** in the **comment** box below. Thank you ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png) !!

### Related Articles:

- **[Enter the Date In Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**
- **[How to Enter a Formula in Excel Office 365 ~ Easy Tutorial!!](https://geekexcel.com/how-to-enter-formula-in-excel/)**