how to change MM/DD/YYYY HH:MM:SS to DD/MM/YYYY HH:MM

I'm hoping someone with some expertise can assist me,

I have Excell 2007 and am having challenges with the date and time showing in the correct format.

I've tried highlighting the column with the dates, then go to Date -> More Number formats and on the number tab selecting Date, Type 14/3/2001 13:30 with the locale (location) Hebrew (Israel) and then click OK. This has not worked for any days numbered 1-12. These revert to the MM/DD/YYYY H:MM:SS AM format


I've also tried hightlighting the column with the dates, then go to the Data Tab -> Text to Columns -> Delimited -> Tab -> on the Column data format clicking Date and choosing DMY and then Finish. This also has not worked for any days numbered 1-12. These revert to the MM/DD/YYYY H:MM:SS AM format


Thank you