=int(A2)

assuming it is a real date and timne cell. Format the cell as just date.

Actually, you could just format the original cell as date. The time will
still be there, it just won't show.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"HeartSA" wrote in message
...
I have this below

8/26/2005 3:19:00 PM

I only want to display

8/26/2005

Can't figure out how to do this. I tried changing the date format to just
date, but it still displays the time. Please help