Forum Discussion
Jipin_daiki
Sep 06, 2021Copper Contributor
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 ...
OEExmentions
Sep 13, 2021Copper Contributor
Hi,
The date format might be linked to your language preference in Excel. Check the language preference in Options>Language. If the language installed is English (United States), the date format will be American (mm/dd/yyyy). If English (United Kingdom) has been installed, the date format will be English (dd/mm/yyyy). You could install your preferred language. I hope this helps.