Text To Date

Hi,
Requesting to help me out with the date issue as below:
I have dates in following form:
020513 which appears in excel as 20513
100513 which appears in excel as 100513
Now when i try to convert this general number into date using text to columns it returns result in this format:
020513 <text to columns> <result> 20-05-13, but infact it should have been 02-05-13.
100513 BUT THIS VALUE RETURNS CORRECT DATE ie 10-05-13
I understand that in first value excel does not counts 02 but it counts 20 from 05 and returns the value as 20
So is there any solution to this
Please reply... very needy

02 date
05 Month
2014 Year

Thanks Sixth Sense
but is it possible via this formula:"=TEXT(A1, "00-00-00")"

What i did that inserted "=TEXT(A1, "00-00-00")" in B1

and then in C1 i inserted
=DATEVALUE(B1)

But your second formula saves me 01 column :-)

Now just for my information, is it possible to add B1 formula and C1 formula together in same column?
=TEXT(A1, "00-00-00") + =DATEVALUE(B1)

Also can you explain what is happening in your below formula!
=VALUE(TEXT(TEXT(LEFT(A1,LEN(A1)-2),"00-00-")&RIGHT(A1,2),"DD-MM-YYYY"))

Shall be grateful for your time

Ahh Forgot!!

Thank You very Much