unrecognisable dates

R

rachelreveley

Hi,

I have a clumn of dates in the format of 20033010 ie 30th oct 2003
Excel unfortunately I can't get excel to recognise this as a date. I
need to turn it in to the format of 30/10/2003 so it should go from
20033010 to 30/10/2003.

Does any body have an idea of how to do this

Thanks :)

(novice)
 
P

Peo Sjoblom

Select the column, do data>text to columns, click next twice, in the column
data format select date and
YDM and click Finish.. This assumes that the format always use 8 digits as
in yyyyddmm
 
A

Andy B

Hi

Use Data/Text to columns. On the way through the wizard you can select that
the information is a date and the format that the date is in.

Andy.
 
L

Lee

put the date you want to change in cell A1 for the
example below....

=CONCATENATE(MID(A1,5,2),"/",RIGHT(A1,2),"/",LEFT(A1,4))
 
Top