Hi Loza

Try
=MID(B2,7,2)&" "&TEXT(MID(B2,5,2),"mmm")&" "&LEFT(B2,4)&"
"&MID(B2,9,2)&":"&MID(B2,11,2)+0

--
Regards
Roger Govier

"loza" wrote in message
...
Saved my mobile phone msgs as xml doc When I open it with excel 2003 Date
and
Time is displayed as

A1 Date/Time
A2 2.00806E+13
Formula Bar displays 20080627155119

How do I format to display as 26 Jun 08 3.35pm as per phone details or
simular date and time format

Regards Loza