Changing date format in excel for mac

J W Norris 1 Reputation point
2021-10-16T22:05:35.69+00:00

I have a list of about 300 dates that I wish to reformat. Some are displayed as dd-mm-yyyy and others as ddd/mm/yyyy. I need to change to mm/dd/yyyy in mass (not one at a time). Can anyone help?

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
493 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,636 Reputation points
    2021-10-18T07:32:37.133+00:00

    @J W Norris

    Could you please check which cell format do you set for these dates? Such as General, Date, Custom.

    Besides, do you mean one date format is "dd-mm-yyyy", and the another one is "dd/mm/yyyy"?
    If yes, you could try the formulas to convert the date format.

    I creat a simple sample as following.
    141257-capture26.jpg

    The formula could be =Text(Date(Right(A2,4),Mid(A2,4,2),Left(A2,2)),"mm/dd/yyyy").
    141283-capture27.jpg

    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.

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.