Forum Discussion
Date format microsoft teams
Hello everyone, I work as an IT Support Tech in a company. Today, a user came with a date format issue on excel but only in teams. She tried to put a french date format in teams, but the ...
You use MM/DD/YYYY????? You're not English. it's DD/MM/YYYY in the UK. At least it has been since I went to School in the 70's
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......