Solved

Excel Converting to ISO format for Date

Posted on 2014-01-14
5
1,168 Views
Last Modified: 2014-01-15
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.
0
Comment
Question by:ibewlocal98
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Steve earned 500 total points
ID: 39780116
Choose custom and enter "yyyy-MM-dd hh:mm:ss" as the type.
0
 

Author Comment

by:ibewlocal98
ID: 39780157
still failing.  I am trying to replicate how excel 2003 used to allow you to change the date locale to International (ISO)
0
 

Author Comment

by:ibewlocal98
ID: 39780174
when i remove the hh:mm:ss it works. Any way to do this automatically without have to type it custom each time?
0
 
LVL 7

Expert Comment

by:Steve
ID: 39780447
Not unless you record a macro changing the column.
Then you could just assign HotKeys and format the whole column with 3keys.
0
 

Author Closing Comment

by:ibewlocal98
ID: 39782135
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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question