I've been incredibly frustrated by this. I live in Europe and my standard date format is DD/MM/YYYY. So when I type in 01/05/2018 I expect Excel to show that or 1 May 2018. But it inverts it to MM/DD/YYYY.
I've looked at many forum threads with similar questions but all I find is temporary and not full solutions. I've tried changing the format to DD/MM/YYYY but it only changes how the date is displayed so there is a discrepancy between how I type it and how it is shown.
I have all my computer settings to DD/MM/YYYY but Excel doesn't seem to be inheriting these.
Please help! What to do?