how to set date formatting in excel for mac 2011

Office for Mere Mortals has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Login using the same account as for OneDrive Excel Online Go to Overview Personal Info Under the heading Home change the countryregion to the one you want as the datecurrency default.

Click Save Reopen the Excel worksheet and the date cells should change their look.

However other people report that instead changing the Work country is necessary.

Yet other reports say that changing the default language is required from the bottom line of Microsoft account.

A detailed and independent look at Windows 10, especially for Microsoft Office.

In Windows, go to Control Panel Region to change the way dates look in Excel.

On Macs System Preferences Language and Region Advanced Dates.

Or you can set a custom date format, as we recommend on page 124 of Office 2013:the real startup guide.

Sure, there needs to be a default and using the one in Windows is logical.

Its also useful if the worksheet moves to another computer with a different date format.

When that happens the same date cells will appear in the format set for that computer.

Or you simply want to enforce a particular date format for consistency and regardless of the computer settings.

It can be confusing for people trying to enter dates and sometimes the wrong date is entered when Excel accepts 12313 as 12 th March 2013 instead of 3 rd Dec 2013.

Office Watch has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Invalid email address Weve been running secure and private newsletters for over 20 years.

Thanks for subscribing Well send you future issues right away.

How To Set Date Formatting In Excel For Mac 2011