Date format

A

AA On Windows

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
 
F

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


AA On Windows said:
Format just hide data , but I need to delete it
Click to expand...
 
Top