How to change date format in Microsoft Excel on Windows


Here is the step by step guide for you to change date format in Microsoft Excel on Windows.

Here, you have to follow these simple steps to change date format in Microsoft Excel on Windows | Photo for Representation

Microsoft Excel is popularly used by the people who are involved with data management, billing, finance, business tasks and much more complex calculation works. The most impressive thing about MS Excel is it saves a lot of time and can store a huge amount of important data within it. It also can store data by date and allows you to change date format according to your choice.

Here is the step by step guide for you to change date format in Microsoft Excel on Windows.

How to change date format in Microsoft Excel on Windows

Microsoft Excel on Windows is easy-to-use software. Here, you have to follow these simple steps to change date format in Microsoft Excel on Windows.

Step 1: First, you have to select the cells you want to format.

Step 2: You need to press CTRL+1 command in the next step.

Step 3: In the Format Cells box, you have to click the Number tab.

Step 4: You have to click on Date in the Category list.

Step 5: Under Type, you need to pick a date format. Your format will preview in the Sample box with the first date in your data. Please note here that date formats that begin with an asterisk (*) will change if you change the regional date and time settings in Control Panel. Formats without an asterisk won’t change.

Step 6: If you want to use a date format according to how another language displays dates, you have to choose the language in Locale (location).

Benefits of using Microsoft Excel

Using Microsoft Excel has several benefits. Microsoft Excel helps to do a powerful analysis of a large amount of data. Through effective and easy comparisons, this Microsoft software also helps its users to summarise one’s data enhancing the ability to structure and organise their data.

(Source: Microsoft Support)

Get real-time alerts and all the news on your phone with the all-new India Today app. Download from

  • Andriod App
  • IOS App





Source link