Format Cells Number tab Custom select m/d/yyy


"magic2821" wrote:

I have an imported set of data which has multiple columns with date/time
format (4/16/2007 8:33:53 AM). I need to sort by date and then count items
with same date, but can't do so because I don't know how to get rid of the
time value. I have found no reference / function in the numerous books, etc
I have that seems to address date/time formats such as this.