=INT(A1) gives just the date
=MOD(A1,1) gives just the time
Format the cells accordingly.
--
David Biddulph

"KrisP" wrote in message
...
How can i remove the hh:mm:ss from the end of a date? I've converted it
to
just date, and it looks as its just date but if you click on the cell you
can
still see the time. I want to be able to group a list by date only and
cannot get ride of the time extension.

Many thanks in advance for your help.