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.