Changing default dates on Excel for Mac

Hi, I have a very annoying issue with Excel for Mac with the date formatting being unable to be switched to dd/mm/yyyy. I run Excel 16.8 on macOS 10.13.1. The current default date format is t...

Excel on Mac

office 365

Barbara Hoffbrand (Mrs)

Copper Contributor

Nov 02, 2023

AntoineDubai I am trying to use the UK date format instead of the US format on Windows but am still having to change it on my tables. I usually just highlight the whole column and change it that way. Every time I need to make the table bigger, I have to do the same thing.

It seems to be a problem for everyone and needs Microsoft to change something which they are not doing.

I hope you find a solution but think it unlikely as I have tried everything I know and know of others with the same problem.