You can apply a custom format to the cells so that only the date is
displayed (but the time is still included within the data), eg mmm dd,
yyyy.

If you want to get rid of the time part completely, then use this
formula in an adjacent column:

=INT(A1)

and format the cell as a date, and then copy down.

Hope this helps.

Pete

On Mar 5, 11:34*am, Robert Blass wrote:
I have a large number of cells with date and time like this, "Jan 12,
2001 5:55 pm"
I want to truncate the time in the cell and only make it display the
date.

Can someone help me?