27
2
I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08
, but Excel automatically converts the date format to 4/8/2012
.
I tried scrolling through the different types of Date formats that Excel allows me to choose from, but the 'YYYY-MM-DD' format isn't there:
Is there a way for Excel to recognize the ISO 8601 date format as a date value (and not automatically convert it to another format) when entered in a cell?
What about for Excel 2011? There is no box to enter a custom format! – Michael – 2016-01-21T17:40:15.670
@Michael Sorry, I've not used nor do I have access to an OS X copy of Excel. Consider asking a new question addressing that version explicitly (and say why this question is not a duplicate). – Bob – 2016-01-21T21:18:07.040