Good Day

How can I convert a date format of mm/dd/yyyy to dd/mm/yyyy?

Example, in my workbook, I have an existing date of 10/24/2022 and when i use the text to columns method (DMY) , it converts it to 24 October 2022, same for 11/08/2022 = 11 August 2022.

BUT, 8/22/2023, 3/30/2023, 11/29/2023, 12/22/2021 remains the same as it not converted.

06/05/2023 = 06 May 2023, so that works as well.