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!