<div>
also you could do this another way <br />
<br />
=TEXT(A1,&quot;mm/dd/yyyy&quot;)
</div>


also you could do this another way

=TEXT(A1,"mm/dd/yyyy")

<div>
ProfessorJimJam's solution but refined:<br />
=TEXT(A1, &quot;MM-DD-YYYY&quot;)
</div>


ProfessorJimJam's solution but refined:
=TEXT(A1, "MM-DD-YYYY")

<div>
<div class="content wysiwyg-content">
I have a long column of dates that look like this:<br />
<br />
7/1/2008<br />
10/13/2003<br />
11/17/2003<br />
02/25/2002<br />
01/01/1999<br />
5/11/1992<br />
9/30/2013<br />
9/1/2011<br />
10/1/2011<br />
<br />
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?
</div>
</div>


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?

Normalize dates in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.