Hi....

I have the date and time in a cell "9/20/2007 6:49:53 PM". Now, I want the
date and time to be displayed seperately in different cells. Eg:-
B2=9/20/2007(Date only-No Time)
C2=6:49:53 PM(Time only-No Date)

Any help will be appreciated....