You can get the date with:

=INT(A1)

and the time with:

=MOD(A1,1)

if your date/time is in A1.

Format the cells appropriately.

Hope this helps.

Pete

On Apr 10, 4:34*pm, "Michel Khennafi" wrote:
good morning

I have a seri of cells where the information inside is like

10/2/2007 *4:38:00 PM

I would like to create 2 columns where in one of them I have the date only
and in the other I have the time only

Any idea as to what is the best thing to ddo?

Help is appreciated ... Thanks