@Mike-And-Jane0
Are you using a CSV file as shown in my picture above?
I have found only one way to format the dates supplied in a CSV as UK dates. It is as follows:-
Select column
Alt-A - E (Displays the "Text to Column Wizard" box)
Select Delimited button - Click Next
Clear all Delimiter boxes - Click Next
Select Date button - Select MDY(from drop-down box) - Click Finish
This works! ⸌(ㆆ‿ㆆ)⸍ @Bhumika @Cathie19
So I have found a solution, but no thanks to @Airbnb ( ͡°Ĺ̯ ͡° )
My point is that we are continually subjected to Americanisms, we now get our language as English(UK)! I could understand if all dates came in YYYYMMDD! That would be logical to facilitate sorting. Apologies for my rant.