Date format issue =Right

[shakery1]

Issue:
I have a data point that is a date but is not in date format. I need the data point to be in day/month/year format.

I have had some luck using the following formula to parse the data but it is not getting me all the way.
=RIGHT(I2, LEN(I2)-4) &"-"& LEFT(I2,4)&""

If I use the above command I will get the following output 0201-1900 but I would like to have 01/02/1900 or even 01-02-1900

My data point looks like so 80999798 then I have to say =99999999-80999798 and I get 19000201.
If i click on the date format in excel I get ##### so I was looking for a formula that I could use to convert this to 01-02-1900

Any ideas?

Chris

[Sam Capricci]

how about this...
=RIGHT(I2,2)&"/"&MID(I2,5,2)&"/"&LEFT(I2,4)

[Bo_Ry]

Please try and change date format to dd-mm-yyyy
=--TEXT(I2,"0000-00-00")

or
=TEXT(--TEXT(I2,"0000-00-00"),"dd-mm-yyyy")
=TEXT(RIGHT(I2,4),"00-00-")&LEFT(I2,4)

[FDibbins]

If the above suggestions dont work for you, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.