=INT(A2)

and

=MOD(A2,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Aom" wrote in message
...
I want to split the date & time in one cell to be 2 colums; Date and
another
colum is Time. i.e. 4/11/2006 14.30
How should I do?