The workaround is to set a custom format for dates but a worksheet-wide setting would be so much more useful and appropriate. It can be confusing for people trying to enter dates and sometimes the wrong date is entered when Excel accepts “12/3/13” as 12 th March 2013 instead of 3 rd Dec 2013.Īlas, there’s no simple way to set a region at the worksheet level and Microsoft has been deaf to any such requests. Or you simply want to enforce a particular date format for consistency and regardless of the computer settings.
![how do you replace formatting in excel for mac? how do you replace formatting in excel for mac?](https://support.content.office.net/en-us/media/644c9c4f-bf6b-464e-84ae-1f2844c57904.jpg)
A user might be working on a computer with a different region setting from the one they prefer. When that happens the same date cells will appear in the format set for that computer. It’s also useful if the worksheet moves to another computer with a different date format.
HOW DO YOU REPLACE FORMATTING IN EXCEL FOR MAC? WINDOWS
Sure, there needs to be a default and using the one in Windows is logical. Or you can set a custom date format, as we recommend on page 124 of Office 2013:the real startup guide. Now, Click on OK to save your new settings. Clear the User name field and enter a new author name. Next, go to the General section and scroll to Personalize your copy of Microsoft Office. On Mac’s System Preferences | Language and Region | Advanced | Dates.Ī worksheet on a computer set to US region will shows dates in mm/dd/yy format like but if you open the same worksheet on a computer with UK region the dates will appear in dd/mm/yyyy or format. To change the default author name in Excel: Open Excel and Click on the File menu > Excel Options. In Windows, go to Control Panel | Region to change the way dates look in Excel. In its infinite wisdom, Microsoft has decreed that Excel’s default for date and currency formats is set, not in Excel, but by the operating system. It isn’t clearly documents what those defaults are.
![how do you replace formatting in excel for mac? how do you replace formatting in excel for mac?](https://i.ytimg.com/vi/qm30__zy7sw/maxresdefault.jpg)
You have to accept the regional defaults set by Microsoft. Unlike in Windows or Mac, there’s no option to customize the date format. Most likely, there’s more to the Excel Online defaults than Microsoft is telling and/or the system is changing over time and without notice.