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.

 

[MARK858]

Try selecting the column - Data - Text to Columns - click Next - make sure nothing is checked - click Next - Check the Date option and choose MDY - click Finish

 

[SunnyAlv]

why don't you reverse the text format to be like this?

=TEXT(A15,"MMMM, DDDD DD, YYYY")

 

[MARK858]

why don't you reverse the text format to be like this?

=TEXT(A15,"MMMM, DDDD DD, YYYY")

A) because the result is text and not a real date
B) because it doesn't reverse the Month and Day i.e with 10/12/2023 the result needed is December, Sunday 10, 2023
C) It doesn't work with the likes of 12/17/2023 which are text if the pc is in dd/mm/yyyy format

Book2
	A	B	C
12	12/10/2023		October, Thursday 12, 2023
13	12/17/2023		12/17/2023
Sheet1

Cell Formulas
Range	Formula
C12:C13	C12	=TEXT(A12,"MMMM, DDDD DD, YYYY")

 

[CHML]

Thanks for trying to help; So far neither of these tips solved the issue.
Attached is what I get when doing SunnyAlv's suggestion; (Remember the correct date is Dec 10)

When I tried following MARK858's steps, nothing changed. Excel displays it as DMY and in the formula bar as MDY. but is fooling by assuming that the service was done in the month of the first two digits at the left, but in fact, the true service dates were all in December.

 

[MARK858]

When I tried following MARK858's steps

Which column did you try it on and did you use MDY or DMY?

 

[CHML]

This was my first step;

Then;

Then;

Results;

 

[MARK858]

The formula bar is correct, format column A as d/mm/yyyy or dddd, mmmm dd, yyyyy (if you want it in the same format as column B in post 1)

 

[CHML]

I changed A5 for example

But it still thinks the moth is January 12, 2023 see bellow

 

[MARK858]

Is your computers regional setting in dd/mm/yyyy? because it changes

to

for me after running Text to Columns