converting binary date to date/time format

[a2424]

i have a list of dates stored via the following :

20100101 how can I convert this to date/time format to show 01/01/2010?

thanks

[AlKey]

In B1

=VALUE(RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4))

	A	B
1	20100101	1/1/2010

format B1 as Date

[a2424]

thanks perfect

[AlKey]

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[[email protected]]

Please find below formula.

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

Regards,
Suhas