converting text to date, please help.

[Guest]

i recently export some data to excel, which give me the date format as text,
example:
20060515

how can i convert it to dd/mm/yy format in excel?

please help.

 

[Guest]

Hi
Select your 'dates' and go to Data>Text to Columns. On the third (I think)
dialog box there is an option in the top right for you to tell Excel that
these are dates - and the format (YYMMDD). Select this and Finish. Make sure
you backup your data before you start!

Andy.

 

[Ardus Petus]

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH

 

[Don Guillett]

one way
=DATE(LEFT(D12,4),MID(D12,5,2),RIGHT(D12,2))

 

[Guest]

i not sure how to rate your answer, but thanks a lot.
many thanks.

 

[Guest]

Max

It is the easiest and quickest way to do the job - without helper cells. I
use it all the time. Why are you not sure how to rate it?

Andy.