=Int(A1) ' provides Date

=A1-Int(A1) ' provides Time



"mebsmith" wrote in message
...
I have cells with the following info:

4/14/2003 14:35

but i need to split so that i can sort by date alone.

how can this be done? i have tried just taking out the data, but that just
treats the "/" as a dividing sign and so get weird numbers.

thanks in advance