Need easy way to remove time from a cell

[penroma]

I have a list of cells that have a date and time in each cell. I nee
an easy way to remove the time, but leave the date. For example, th
cell may have 12/29/2003 5:39:57 PM. I only want 12/29/2003. When
try to format the cell, it looks correct, but the time is still on th
formula bar. Any ideas?
Thanks

 

[Frank Kabel]

Hi
one way (if your time is stored in A1)
=INT(A1)
format this result as date

 

[penroma]

Thanks Frank...that works