Feb 14 2022 03:32 AM
Hello,
When I export my plan from Microsoft teams, the format of the date is still general.
But when I run my the formatting of the date jumps on:
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?
Feb 14 2022 05:49 AM
The way to fix is to convert texts which looks like dates into the dates (which are numbers in background) and after that apply desirable format to them. One of the eays
- select column with such texts
- Data -> Text to Columns
- on the third step of the wizard select date and DMY
Feb 14 2022 06:01 AM
Feb 14 2022 09:29 AM
Perhaps, but that's not my territory.
In general it could be easier to sync regional settings for your Microsoft Teams and desktop app; or adjust export script if you don't do that manually.