Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM