Excel Converting to ISO format for Date

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.
ibewlocal98Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SteveConnect With a Mentor Commented:
Choose custom and enter "yyyy-MM-dd hh:mm:ss" as the type.
0
 
ibewlocal98Author Commented:
still failing.  I am trying to replicate how excel 2003 used to allow you to change the date locale to International (ISO)
0
 
ibewlocal98Author Commented:
when i remove the hh:mm:ss it works. Any way to do this automatically without have to type it custom each time?
0
 
SteveCommented:
Not unless you record a macro changing the column.
Then you could just assign HotKeys and format the whole column with 3keys.
0
 
ibewlocal98Author Commented:
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.
0
All Courses

From novice to tech pro — start learning today.