Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that have a date. In other words ...

When you enter a date that's formatted with slashes, Excel will recognize it as a date ... Choose from formats that put the day before the month, drop the year, and more. We chose the last ...