5
2
Note: I see several questions (q1, q2) on this topic that describe how to accomplish this with the Windows version of Office, but I haven't found anything on Mac version of Office.
I'm a US user, and I want to change the default date format of Excel to YYYY-MM-DD so that if I open an Excel sheet or a CSV file with dates, it displays this format in the column. (In the case of a CSV file, if the format is already YYYY-MM-DD, I don't want it switch to the default format).
Alternatively, how can have this format show up as an option under Format Column -> Date -> US Dates? I end up having to switch my country to Belgium before I can find this option.
(<rant>@Microsoft -- I'm pretty sure in 2016, people in the US use the YYYY-MM-DD format; at least make it an option!</rant>)
FWIW, I used the Feedback feature of Office 2016 to request this feature. Maybe others can do the same to help drive change :) – Dolan Antenucci – 2016-01-15T15:12:51.227
Under Windows, if you set it at the OS level, it applies as default to Excel too; I don't know for Mac. - If you don't want this for your whole system, you can add a format of the type 'date' and apply it to all places where you use dates; that is not changing the default, though. – Aganju – 2016-01-16T02:20:46.657