Forum Discussion

Christos Savva's avatar
Christos Savva
Copper Contributor
Nov 16, 2017

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
AntoineDubai's avatar
AntoineDubai
Copper Contributor
Nov 02, 2023

Christos Savva 

I am using  Excel 16.78.3 on a Mac fitted with Sonoma 14.1.
I would like also to use the system day, month, year  when I type a date.
When I type 1/2/23 it comes as January 2nd  and I need it to be February 1st. 
I tried to go to System Setting >> General >> Language and Region and set the date format as dd/mm/yyyy but it did not change the way Excel behaves. 

Did you find a solution to your issue.

Thanks
A

  • Barbara Hoffbrand (Mrs)'s avatar
    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.

    • AntoineDubai's avatar
      AntoineDubai
      Copper Contributor
      Nov 02, 2023

       

      Thanks Barbara for your message.

      Let's wait for Apple or Microsoft to find a solution.

      Best regards,

      A

Resources