Hi hbcobra
To extract the data as a date, assuming the data is in A1:
=INT(A1) & format the cell as "dd/mm/yyy" or how ever you require.
To extract the date as a text value:
=TEXT(A1,"dd/mm/yyy") change the format to suit your requirement.
Kevin
Quote:
Originally Posted by hbcobra
Hello,
I have a column of cells where both a date and time are included in each. For example, "01/17/2007 12:13:14" (everything is in the "mm/dd/yyyy hh:mm:ss" format). I would like to delete the time stamp from each cell but leave the dates. How do I do that?
Thank you
|