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. 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.
0 kommentar(er)
