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?