convert into date foramt

Hi everyone

i have two dates in following format

6082009
29042009

in two cell vertically

i want to convert into
06/8/2009
29/04/2009

please help me

Hi,

Try this formula in B1 (suppose A1 is "6082009"):

Formula:

Please Login or Register  to view this content.

This will convert your numbers to a date format, the formatting then needs to be applied through the cell formats. Alternatively, if you are happy for the value to be text that looks like a date, use this formula:

Formula:

Please Login or Register  to view this content.

Hope this helps