Convert number to date?

[teeb]

I have a 6 digit number in a cell, say "980601" which is 1st June 98.
Can anyone help me get a formula/format that will conver this number to
the date format?

Thanks,
Teeb

 

[Norman Jones]

Hi Teeb,

Try:

=DATEVALUE(RIGHT(A1,2) & "/" & MID(A1,3,2) & "/" & LEFT(A1,2)