Date formating issues teams export to excel

Hello,



When I export my plan from Microsoft teams, the format of the date is still general.

Screenshot 2022-02-14 122810.png


But when I run my the formatting of the date jumps on:

Screenshot 2022-02-14 122900.png

This is a part of the code:

Range("F5:F100").NumberFormat = "dd-mm-jjjj"
Sheets("Tasks").UsedRange.Replace What:="\j\j\j\j", Replacement:="jjjj"



And that doesn't work, is there a way how I can fix this?

Try this line instead:

Range("F5:F100").TextToColumns

It will hopefully force the text dates into actual dates.

BSB

I just tried it.
Attachment 768260
And for some reason, it works on some. But it won't work for the rest.
The text tot the right is where it worked, but all the text to the left are still the same (general format)

The attachment doesn't work. Follow the instructions in the yellow banner at the top of the page to attach a file.

I'm guessing the reason some worked and others didn't is all to do with your date settings. If the dates come in as dd/mm/yyyy and you use mm/dd/yyyy, or vice versa, then it will struggle to change some.
For example, if 10/11/2021 could be 10th Nov or 11th Oct depending on your date settings and can be interchanged (not always correctly, so you'll need to check your results).
But 13/11/2021 can only be 13th Nov and not 11th of some made up month.

BSB