Can excel convert a date to text

[Hamed parhizkar]

If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008?

 

[Gary''s Student]

=YEAR(B3)+DAY(B3)*10000+MONTH(B3)*1000000 and format as general

 

[Charlie]

=TEXT(A1,"MDDYY")
or
=TEXT(A1,"MDDYYYY")

 

[siva.k]

You can use custom date format option.

Select the cell, then goto

Format Cells -> Custom -> mdyyyy

The advantage is that while you edit, excel shows the format in date format
itself, 6/27/2008. While you leave the cell it will show as 6272008. Hope
this helps.