Convert part of TEXT content to DATE in new Column

[allanTeh]

I have a Column (let's say Column 'A') that store data such as:-

A1 : 8/27/2006 20:00
A2 : 7/26/2006 19:45
A3 : 8/24/2006 19:30
etc...

I want to store data in Column 'B' the DATE portion (the FIRST portion BEFORE SPACE in Column 'A').

I used below's formula but the result are as below:

=LEFT(A1,FIND(" ",A1&" "))

B1 : 38956.8333333333

PROBLEM :

How to make Column 'B' store REAL DATEs that can be SORTED ?

Pls HELP !!!

 

[pgc01]

Hi allanSg

The date is the integer part of excel' s DateTime

In B1:

=INT(A1)

format b1 as date

Hope this helps
PGC