JT,

You can do this with INT(A2), formatted for the date format you want. But
there may be no need, if you're using Excel's date/time functions, or just
want to show only the date. Just format as desired. Format - Cells -
Number - Date, as desired. Or use Format - Cells - Number - Custom, and
roll your own date formats.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"JT" wrote in message
...
I need to be able to separate the Date and Time from thousands of entries
that are list as follows:

2/6/2005 2:36:45 PM

If the above is in the same cell, how can I get 2/6/2005 separated out
into
its own cell?

Thank you.