Date not recognized

[juan.doe]

Is there a way this date Wed Feb 19 12:39:07 EST 2014 be change to "2/10/2014 1:24:12 PM" using a formula?

[bebo021999]

Why does it change from Feb 19 to Feb 10, and 12:39 to 1:24 PM?

[:) Sixthsense :)]

Mis-Interpreted, so taken back

[Punnam]

Hi ,
Similar post matchs your requirement check this could be helpful
http://www.excelforum.com/excel-gene...d-a-fix-2.html
Try post 16 of Norie

Punnam

[juan.doe]

^still getting #N/A using the formula in the link posted above.

[Punnam]

=TEXT(TRIM(TRIM(MID($A1,9,2))&" "&MID($A1,5,3)&" "&RIGHT($A1,4)&" "&MID($A1,11,8))+0,"dd/mm/yyyy hh:mm AM/PM")

try this considering that you have data in cell a1
If not working, provide sample workbook with enough data to explain

Punnam