about date format


I'm trying to import date data.

I failed importing as date format, so changed to text then succeeded.(below "week date")

Next I'm thinking that changes to date format.

So I tried using Mid function and Date function, but the value wasn't filled with cell.

What should I do or is there good way to import date??


Best regards.




Best Answer