<div>
still failing. &nbsp;I am trying to replicate how excel 2003 used to allow you to change the date locale to International (ISO)
</div>


still failing.  I am trying to replicate how excel 2003 used to allow you to change the date locale to International (ISO)

<div>
when i remove the hh:mm:ss it works. Any way to do this automatically without have to type it custom each time?
</div>


when i remove the hh:mm:ss it works. Any way to do this automatically without have to type it custom each time?

<div>
Not unless you record a macro changing the column.<br />
Then you could just assign HotKeys and format the whole column with 3keys.
</div>


Not unless you record a macro changing the column.
Then you could just assign HotKeys and format the whole column with 3keys.

<div>
Thanks for leading me in right direction, I will open new question for part two of this. Using yyyy-mm-dd works. Also selecting English (Belize) will give you option for correct format as well.
</div>


Thanks for leading me in right direction, I will open new question for part two of this. Using yyyy-mm-dd works. Also selecting English (Belize) will give you option for correct format as well.

<div>
<div class="content wysiwyg-content">
Hello,<br />
&nbsp;With previous versions of excel I would be able to right click on column, format, date options and select ISO as the date format.<br />
<br />
I cannot figure out how to do this with office 2013 and need my dates to be in this format.<br />
<br />
I am running WIndows 7 Pro, office 2013.
</div>
</div>


Hello,
 With previous versions of excel I would be able to right click on column, format, date options and select ISO as the date format.

I cannot figure out how to do this with office 2013 and need my dates to be in this format.

I am running WIndows 7 Pro, office 2013.

Excel Converting to ISO format for Date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.