excel date conversion

seek a formula! I used to
####-#-## solution, it is the emergence of rigid 2008-0-12 mistake!
the way to resolve it under the formula?!
Guixie!

you dizzy, do you use formula,

custom.there are so many dates.I made the mailbox dongniansu@126.com, you have to excel all the command = DATE (MID (A1, 1,4), MID (A1, 5,2), MID (A1, 7,2)) should pay attention to the issue of the difference in time, ah

pay special attention to

.07 – 08

= TEXT (H1, “YYYY-M-DD”) the kind of errors occur, you must be out of all the H Date Data is data format, instead of your custom of “YYYYMMDD” date format, that is, 20,080,212 ordinary digital format.
An insert, enter the formula
= DATE (MID (H2, 1,4), MID ( H2, 5,2), MID (H2, 7,2))
and then hide the original H out.= TEXT (H1, “0000-00-00”)

added:
can Custom for 0000 “-” 00 “-” 00