lejon

The below formula converts:

Unix Date: Tue Dec 10 13:18:11 CET 2013

In Excel cell A1 into an

Excel understandable date: 2013-12-10 13:18:11

Formula in B1:
=RIGHT(A1;4)&”-“&IF(LEN(MATCH(MID(A1;5;3);{“JAN”;”FEB”;”MAR”;”APR”;”MAY”;”JUN”;”JUL”;”AUG”;”SEP”;”OCT”;”NOV”;”DEC”};0))>1;MATCH(MID(A1;5;3);{“JAN”;”FEB”;”MAR”;”APR”;”MAY”;”JUN”;”JUL”;”AUG”;”SEP”;”OCT”;”NOV”;”DEC”};0);”0″&MATCH(MID(A1;5;3);{“JAN”;”FEB”;”MAR”;”APR”;”MAY”;”JUN”;”JUL”;”AUG”;”SEP”;”OCT”;”NOV”;”DEC”};0))&”-“&MID(A1;9;2)&” “&MID(A1;12;2)&”:”&MID(A1;15;2)&”:”&MID(A1;18;2)

In Sweden the argument separator in Excel is “;” while otherplace it can be “,” so you might have to change that in the formula.

Elegant! (Joke)