Change Date Format in Excel

[cjg1901]

Hi all

Hoping someone can help me with this:

I have a column with DOB entries like this Aug 27 1982 - I need it displayed as 27/08/1982.

Aug 27 1982 is not a "date format" in Excel so when I try to display it as "Short Date" it does not work, please help?

Thanks
Caroline

 

[Trevor G]

Select your column of DOB then use Ctrl + 1 to go into Format Cells, then at the bottom left select Custom, then on the type line use dd/mm/yyyy

D = Day
M = Month
Y = Year

 

[VoG]

Hi. Try this. Select the dates, Data > Text to Columns, tick Delimited, click Next twice, tick Date and select MDY then click Finish.

 

[cjg1901]

Hi. Try this. Select the dates, Data > Text to Columns, tick Delimited, click Next twice, tick Date and select MDY then click Finish.

TrevorG - I tried your way it didn't work

VoG - thank you so much, it worked!!!