Forum Discussion
Date format microsoft teams
thomasmartinez The only way i have accomplished this is to choose the column, and go to Format Cells and choose CUSTOM and then insert the format want mm/dd/yyyy or whatever date format you need.
- With regard to Excel, I have this problem on one particular spreadsheet which I now believe to be slightly corrupt. It always thinks my dates are US and my currency keeps magically reverting to US$. My suspicion, but this is for another thread, is that the corruption has crept in because I share the spreadsheet with a colleague in India whose Locale, naturally enough, is Indian and that interleaved saves have corrupted the file. It is so badly damaged that I can copy the data from the affected sheets to a brand new correctly formatted XLXS and it takes the problem with it......
Thanks Bikky - where it says "In the UK (That's England, Scotland and Northern Ireland) we use MM/DD/YYYY as you do in France." I did of course mean DD/MM/YYYY, so call it an important 'inadvertent typo'.
My point is this - the date format of any windows programme that follows Microsoft's own rules should get it's locale information from the workstation and use whatever that's set to to display currency, date etc. The excuse for teams appears to be that because it's a cloud based app it has to be set up individually by each user. To me that looks like a rather lame excuse.....
