Trying to convert dates from 1/1/2020 to 01/01/2020

[pack605]

Apologize if this has been answered but I couldn't find a thread on it. I'm using Excel 365 and trying to convert a entire column of dates to xx/xx/xxxx from x/x/xxxx or xx/x/xxxx. I highlighted the column and selected format cells > Date > then my selection, but it's not working.

 

[mole999]

custom format dd/mm/yyyy

 

[pack605]

Actually want mm/dd/yyyy, but regardless, I tried it without success. If you look at my video here it shows what I did and the results.

 

[kennypete]

Are you sure that there aren't ' characters preceding your dates? E.g. A1:A2 below versus A3:A4:

 

[sandy666]

maybe
select dates
Data - Text to Columns - Next - Next - Date (MDY) - Finish

 

[pack605]

Are you sure that there aren't ' characters preceding your dates? E.g. A1:A2 below versus A3:A4:
View attachment 6043

Definitely nothing before the dates.

 

[pack605]

maybe
select dates
Data - Text to Columns - Next - Next - Date (MDY) - Finish

That worked. Thank you!

 

[sandy666]

That worked. Thank you!

You are welcome
Thanks for the feedback

 

[jim may]

Select A3:A4 - Goto Format Cells, Select Custom. then replace mm/dd/yyyy in box showing the text "general" -then OK out

Book1
	A
1	11/7/2019
2	1/2/2019
3	11/07/2019
4	01/02/2019
Sheet1

Cell Formulas
Range	Formula
A3:A4	A3	=A1+0

 

[pack605]

Select A3:A4 - Goto Format Cells, Select Custom. then replace mm/dd/yyyy in box showing the text "general" -then OK out

Book1
	A
1	11/7/2019
2	1/2/2019
3	11/07/2019
4	01/02/2019
Sheet1

Cell Formulas
Range	Formula
A3:A4	A3	=A1+0

Thanks Jim!