HELP - converting ODBC data Text Dates

[Kevin Page]

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 this forum.

Does anyone have a recommended solution to this??

[#2]

Hi Kevin,

If that's a text you may use Data->Text to Columns selecting on third step of the wizard proper date format (YMD)

[#3]

THANK YOU!! Worked perfectly!!