Question: how to change date format in excel from american to uk?
Answer: Select the column of dates.
Under DATA, select “Text to Columns”
Select Delimited – Next.
Untick ALL delimiters – Next.
Select column format “Date: MDY” – Finish. ... 
The text will now be recognised by Excel as a date and appear as right-justified in the column.