With data in Column A,
In B1 enter
=A1
and copy down as needed,
Then, custom format Column A to perhaps
mm/dd/yyyy
AND
Custom format Column B to perhaps
hh:mm AM/PM
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Dan B" wrote in message
...
Hi,

I data in a column with the date and time like this:
1/3/2006 7:30:00 AM

I need to have the date in one column and the time in the next.

Thanks!!