As an Office 365 user in the UK running Microsoft Excel 2008 for Mac version12.0 under OS X 10.9.5 I find in incredibly annoying not to be able to enter dates in UK dd/mm/yy format. Previously I could enter 12/3 and it would automatically expand to or 12/3/15 or 12 March 2015, depending on how I had defined the cell. Instead, even though the cell is defined as dd/mm/yyyy, when I enter 12/3, I get. Recently I had an email advising me that I could upgrade to Office 2016, so I thought this might help, but I can't even sign on to Microsoft Lync. Which windows for mac. Please advise. Hi Andy, After some research, I have found two ways to change the date format for your reference. • Open the Excel application> Go to the top menu bar> Click Format> Select Cells and click on the Number tab>Select Date in Category > You will see a list of types, select the one you want from there > OK.

• Open the Excel application>Select the column with the date> Choose Data on the top menu bar> Text to Columns>Click Next> Next>In the third pane of the dialog, select the Date: radio button and choose DMY from the dropdown>Click Finish. Since this issue is relate to the Excel for Mac and our forum focuses on Office 365 for Business Online services, we suggest you post a new thread on our for expert support.You can sign in to the Office community and click Participate -> Ask a Question to post the question. For upgrading to Office 2016, in order to have you get the dedicated support and help other community members who are experiencing the same issue search your thread more easily, and make this post more clearer to response the one specific question, it is recommended to to help you more efficiently. After that, we can focus on the details of your exact scenario to provide support.

The Missing Plug-in prompt may also display if you have an outdated version of the plug-in, allowing you to update your Mac with the latest version. To view the content, you will need to install the missing plug-in. Below we show you how to install missing plug-in with Mac OS X. Install plug in for mac.

Mar 05, 2018  How to Compare Dates in Excel on PC or Mac Co-authored by wikiHow Staff This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.

We would highly appreciate it if you could add the following detailed information in your new post: • What Office 365 subscription do you have? • Check whether you can view the Office 2016 for Mac via. • Check whether you can see The latest desktop version of Office under Assigned license via. • Check whether you use the Office 365 work or school account to log into the Lync(it is called Sky for Business now).

Thanks for your understanding.