Convert date format to (dd/mm/yyyy)

Dear all, i need to convert the date format form 20042008 to 20/04/2008

Try highlighting the column of numbers
Data - Text To Columns
Deliminated - Next
UNcheck ALL options - Next
Date - YDM
Finish

Hi Jonmo, it works , but i need to solved by formula. as it having in the multiple cell..thanks..

I don't understand....
Text To Columns CAN do multiple cells...An entire column if needed.

Anyway, in a formula you could use

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

Hi Jonmo, it goes to results as 8/20/2004 except 20/04/2008

I think you need the following:

=DATE(right(A1,4),mid(A1,3,2),left(A1,2))

Hope this helps.

Pete

Oh crap, I was reading 20042008 as Aug 20 2004...LOL

Pete's got it right..


Also, in my original post using text to columns..

This
Date - YDM
should be
Date - DMY

Hi Pete , thanks it works perfectly..

@ Jonmo .. thanks...