Formatting date & time
 

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.

Formatting date & time
 

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)

"Jodi Bauman" wrote in message
...
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.

Formatting date & time
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jodi Bauman" schrieb im Newsbeitrag
...
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.