Normalize dates in excel

I have a long column of dates that look like this:

7/1/2008
10/13/2003
11/17/2003
02/25/2002
01/01/1999
5/11/1992
9/30/2013
9/1/2011
10/1/2011

I need leading zeros in front of all the days and months in each cells. Or at least a leading zero on the days under ten. OR is there anyway to convert all these dates into this format YYYYMMDD?
LVL 1
roosterupAsked:
Who is Participating?
 
ProfessorJimJamCommented:
put this in column B

=TEXT(A1,"YYYYMMDD")
0
 
ProfessorJimJamCommented:
also you could do this another way

=TEXT(A1,"mm/dd/yyyy")
0
 
David L. HansenProgrammer AnalystCommented:
ProfessorJimJam's solution but refined:
=TEXT(A1, "MM-DD-YYYY")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.