Can excel convert a date to text
=TEXT(A1,"MDDYY")
or
=TEXT(A1,"MDDYYYY")
"Hamed parhizkar" wrote:
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?
|