Formatting date & time

J

Jodi Bauman

I am importing a file from another program and the date
and time displays as follows: 200403111449. How do I
format this date, so that it shows 3/11/04 14:49 - either
in 1 or 2 cells.
 
B

Bob Phillips

Format the cell as d/mm/yy hh:mm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
try the following formulas
B1:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
format as date

C1:
=TIME(MID(A1,9,2),RIGHT(A1,2),0)
format as time
 
Top