Forum Discussion
Excel Date format problem
Hi, I tried everything but seem to be stuck here with this issue though I believe I might be missing a simple solution. I have two dates: 03/09/2021 02/09/2021 Excel is taking it as m/d/yyyy ...
HI Jipin_daiki
I had the same problem when I bought a new Desktop (Mac) and the new Office 2021.
I had to change language and region to Canada English (which has dd.mm.yy as standard) not just on Excel but also on my MAC OS configurations.
Don't know if you are using Microsoft but on the new Monterey just go to System Preferences - Language & Region - Advanced and them change it the way you prefer.
Hope that helps you.