Date & Time Conversion from xml import

  • Thread starter Thread starter loza
  • Start date Start date
L

loza

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
 
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
 
Back
Top