English & Hungarian Date format

I have the following date. Forexample: Sep 20 09:28:23 2012
I would like to format it (with DATEVALUE() ), to look like: 2012.09.20. 09:28:23
But my excel manage the date format with Hungarian format and not English.
I tried to change the location in the format cells option to english, but it doesn't work.
Some value return good, but mostly throw a #VALUE! error.
For Example

Sep 20 09:28:23 2012 #VALUE!
Feb 27 17:08:56 2012 2012.02.27 00:00:00
Oct 16 13:37:55 2012 #VALUE!
Oct 16 13:37:55 2012 #VALUE!
Feb 20 12:02:09 2012 2012.02.20 00:00:00
Dec 20 12:02:09 2012 2012.12.20 00:00:00
Sep 20 18:21:29 2011 #VALUE!

Assuming those date/times are in column A, you could use this formula in column B:

=DATE(RIGHT(A1,4),MATCH(LEFT(A1,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),MID(A1,4,3))+MID(A1,8,8)

and then copy down.

Hope this helps.

Pete

Thanks, it works.