I have a column with dates in format yyyy/mm/dd
I copy dates from other excelfiles that has the date format yyyy-mm
When I copy the dates with the DATE format yyyy-mm, they keep that format even if the new column is set to DATE format as yyyy/mm/dd.

I would like the dates with the format yyyy-mm to automatic change to yyyy/mm/dd when I paste them in my column.

Please if anyone have some ab code that could help me with this do tell me and were I chould save it. I have already tried many ways but does not get it to work, and I can't download any converter to do the job for me. So Thank you for helping.