Date formatting issue

[CHML]

Hi, After downloading a report, I noticed that somehow, Excel caught up services for (in this image scenario) December 10, 2023, as October 12, 2023 (in numeric format).
How can I tell Excel to treat the 2 first digits on the left as the Month, and the mid as days? If I simply do by formatting to "mm/dd/yyyy" It still thinks its October and shows as 10/12/2023.

If you help with a formula perspective, consider there are some dates that have only 1 digit as the day.

Thanking you in advance.

 

[CHML]

I actually don't really have access to download a new report, but I do have the original report in my email - if that helps.

 

[MARK858]

Save a fresh copy, carry out post 17 and see if the ISNUMBER formula gives TRUE for all the cells

 

[CHML]

I first copied column A to a new workbook if you would want to try play around. see attached.

 

[CHML]

Oh, I think the system spits it out. it allows pic formate only.

 

[MARK858]

Upload the file to a free file hosting site like www.box.com or www.dropbox.com, mark the file for sharing and post the link it provides in the thread.

I will need to change my systems dates to mm/dd/yyyy (which I won't be doing tonight btw), and I'll look at it when I get a chance.