unrecognisable dates

  • Thread starter Thread starter rachelreveley
  • Start date Start date
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)
 
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
 
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.
 
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))
 
Back
Top