How to solve the date format problem in Microsoft Excel

Who I am
Catherine Le Nevez

Author and references

Microsoft Excel is one of the best programs for organizing data in tabular form; Excel is widely used around the world due to its simple yet powerful features. However, there is a small learning curve in Excel, which many people see as a hindrance.

The date format is one of the things that most users find difficult to change from the default option. Different countries use different date formats, so many users will want to change the date format in MS Excel. There is no direct option to change the date format in the main menu, so basic users face problems using different date formats.

To make your work more convenient, we've discovered two simple ways to change the date format in your document. The first method changes the MS Excel settings to enable different date formats for you and the second method changes the default date format on your computer, so you don't have to change the settings every time you create a document. It will also change the default date format in all your programs. Choose the one that suits you best.

Method 1: data settings in Excel

1 STEP: Click on Data tab in the main menu and then click Text in columns option.

2 STEP: A pop-up menu will open, select the file Delimited radio button under “Original data type”, then click The next twice to go to step 3 of the wizard.

PHASE 3: In the third step, first check the date option in column date format and then select MDY from the drop-down list. Click To finish after selecting the date format.

PHASE 4: Select an empty cell within the document and press Ctrl + 1, the cell format the menu will appear.

STEP 5: Please select custom from the categories menu in the left panel and then click on the type option. Write the date format as aaaa-mm-hh (Enter the desired size or choose by scrolling down.)

IT IS GONE 6: Click on ok apply the date format. Check the date format by typing the date in any of the cells.

Method 2: change the Windows default date format

If you are looking for a permanent solution for date format in Excel and all other applications as well, changing the default date format will be the best option for you. It will automatically change date formats in all apps and you don't have to worry about it anymore. Follow this simple procedure to change the default date format on your Windows computer.

1 STEP: Press Windows + R, it will open the Run box.

2 STEP: To write international control in the box and hit enter.

STEP 3: The region settings menu will open, choose the desired date format option from the drop-down menu.

PHASE 4: Click on ok to save your settings.

add a comment of How to solve the date format problem in Microsoft Excel
Comment sent successfully! We will review it in the next few hours.