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

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

Hi

Depending on which version of Excel you are using:

< 2010:

Tools | Format Cells | Number Tab

2010:

Format | Format Cells | Number Tab

Choose Date, select whichever Display format you like including a custom
format of your own choosing.

HTH
Mick.

Hi,

Am Fri, 22 Mar 2013 20:38:31 +0000 schrieb hbcobra:

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?

if formatting as "mm/dd/yyyy" is not that what you want, you can try
TextToColumns = Delimited = Delimiter = Comma = select the column
with the time and choose "Do not import (skip)"
Then your date and time
01/17/2007 12:13:14 changed to
01/17/2007 00:00:00 and you only have to format the column as date


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2