Share via

How to permanently change the format date in Excel from d-m-yyyy to m-d-yyyy?

Raven Sam 0 Reputation points
2023-09-04T05:17:56.3333333+00:00

Hi Guys,

I'm hoping that someone can assist me in resolving an issue with my Excel. I've already adjusted my PC's regional date format to (English, United States) in an attempt to change the date format in Excel from Day-Month-Year to Month-Day-Year. However, I've encountered a persistent problem where, no matter how I input the date as MONTH-DAY-YEAR, it consistently reverts back to DAY-MONTH-YEAR, which is not what I want. For instance, if I type 12-31, it automatically displays as 31-Dec. Can anyone provide a permanent solution to rectify this?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,106 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,705 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
F#
F#
A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
71 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,979 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenXu-MSFT 20,971 Reputation points Microsoft Vendor
    2023-09-04T06:55:58.9066667+00:00

    Hi @Raven Sam,

    Select the column and right-click, select "Format Cells...", click "Custom" under Category and Type: "m-d-yyyy", click "OK" to save.

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.