Fixing my date format

[robertdino]

I have a huge excel sheet with dates in MM/DD/YYYY format (ex. 29/05/2020)

Problem is that some of the cells are in M/DD/YYYY format which is possible when the month number is a unit (less than 10), obviously (ex. 6/05/2020)

Now I want to change all cells to DD/MM/YYYY format and I am unable to do this because all cells that have a number in MM beyond 12 convert properly but those with MM as 12 or below remain in the same MM/DD/YYYY format.

Can someone help? I bought Kutools too.

 

[Dave Patton]

robertdino you may consider reading and trying the information in post #6

 

[Alex Blakenburg]

this fixed everything.

Thanks for letting us know. Dave and Anthony had you covered, I just presented it in a different way which seemed to work better for you .