Share via

Converting date format

Anonymous
2019-01-25T22:25:27+00:00

Downloaded a file from Australia that shows dates as DD/MM/YYYY in a column in a spreadsheet. I need to change that to MM/DD/YYYY format. Formatting the cells to new format does not change, like 6/12/18 shows June 12,18. In American format it should read Dec 6,18.

How do I convert ?? HELP !!!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2019-01-25T23:36:55+00:00

    Hi,

    Select the range of dates and go to Data > Text to columns > Next > Next > Date > MDY > Finish.  If it does not work, then try DMY.

    Hope this helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments