Forum Discussion
Date formating issues teams export to excel
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 cod...
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
- Isn't there a way to do this with VBA?
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.
