Changing a date format from US to UK

Yusuf

Active Member
Joined
Jun 1, 2004
Messages
337
Hi all

I need advice with changing a date format from US to UK format.

At the moment, the report shows the dates as mm/dd/yy and I need it to be dd/mm/yy
When I format the cells it shows in the proper format but I still have the problem when Sorting the dates.

08/01/05 should be 1st of August but shows as 8-Jan-05

I even tried using Right, Left and Mid functions but only get the Text returning, eg. 38360, 38361 etc

Please help if you know if it's possible
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
Yusuf

Select the column with the dates.

Goto Data>Text to columns...

On the 3rd step chose Date for Column data format and MDY from the dropdown.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,509
Members
412,599
Latest member
Schu94
Top