Strip Out Time
 

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

=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

First, make sure what you have in your cell is truly an "Excel Date"
(which is a number that Excel interprets as a date) by changing the
format of the cell to General. The cell should now show the "Date
Number" of 38590.63819 (or similar). If it still shows "8/26/2005
3:19:00 PM", then what you have is a TEXT entry and changing the format
will not alter it.

What do you find?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475984