Imported date formula converting to excel date-formula

[lekcso]

I imported data from a system which has no interface with excel (we use excel 2003)
the text in the date column is like this:
"16.03.2011 06:52"

I'd like to trim the last 6 character, and transform the text into date formula.
How can I do that?

THX
lekcso (Hungary)

 

[VoG]

Try

=DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2))

 

[lekcso]

thanks!
it worked, but not in the same form exactly.
I used the left formula only, because the date function didn't work with the 'left'.
the source data was not in date format... maybe this was the problem.
lekcso

 

[VoG]

It worked for me with your sample data

Excel Workbook
	A	B
1	16.03.2011 06:52	16/03/2011
Sheet5

 

[lekcso]

finally it is correct, you were right, but in the Hungarian excel you need not to use "," but ";"
thx
lekcso