HELP - converting ODBC data Text Dates

Using ODBC linking, the dates comming over into Excel are in text format "YYYYMMDD".  I have tried every way I can to convert to a numbered date format, but nothing works, even other suggestions in t...