Date format

[Guest]

I have list of Date and time in the column,
but I need Date only , not date and time,
I was try to use format sell , but it just hiding time but not deleting it.
Is any way I can separate date and time and delete time in 1 shot ?

LastActionDate
1/2/2006 9:09
1/2/2006 9:22
1/2/2006 9:33
1/2/2006 9:35
1/2/2006 9:35
1/3/2006 10:22
1/5/2006 11:01

 

[Carim]

Hi,

Just type =Int(A1)
and copy all th way down ...

HTH
Cheers
Carim

 

[Bob Phillips]

You could just format as m/d/yyyy

 

[Guest]

Format just hide data , but I need to delete it

You could just format as m/d/yyyy

 

[Guest]

Sorry , did not got it ..? how ?

 

[Guest]

Yes , it is working , but I got 1/2/2006 0:00 ,
but only need 1/2/2006

 

[Fred Smith]

There is no such thing as deleting a time of 00:00. In Excel, dates are the
number of days since Jan 1, 1900, and times are a fraction of a day. When you
enter a date of, say, 1/2/2006, you will automatically get a time of 00:00.
Everyone else handles this by using a date-only format. Why can't you?

--
Regards,
Fred

Format just hide data , but I need to delete it

 

[Guest]

Try this

=TEXT(A1,"m/d/yyyy")