+ Reply to Thread
Results 1 to 11 of 11

Change default date format from date-month (ex: 29-Jul) to 7/29/2013

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    To be clear, I want to be able to enter 7/29 into a cell and receive 7/29/2013 NOT 29-Jul.
    (It is time consuming to go through the process of formatting the cells via the 'format cells...' option)

    I have gone through the region and language settings in the control panel, but this did not remedy the problem.

    I have found numerous threads about this issue but none have a solution.

    Please, someone tell me they have figured this out.

  2. #2
    Registered User
    Join Date
    07-26-2013
    Location
    Davao City, Phlippines
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    I use MS Excel 2010 without changing the for i try to enter 7/29 and the result is 7/29/2013. Maybe your excel is already formatted to came a date of 29-Jul. try to open new excel and try to enter 7/29.

  3. #3
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    I use MS Excel 2007 as well, but any and all sheets that I open default to the format 29-Jul when 9/29 is typed in a cell.

    Someone please help me figure this out.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,377

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    I use that and excel for mac, I just tried it and it came out as 29-Jul as you noted. Then I just went to format cell and selected Date then 3/14/2001 (the example in excel) and it came out as you wanted.
    You can highlight the column and it should format all as that or use the format painter to do same on a whole column.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    Yes, format cell works but when entering hundreds of data points with corresponding dates that need to be formatted MM/DD/YYYY having the DEFAULT format be MM/DD/YYYY would be preferred. Reformatting every single cell is time consuming.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,377

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    You can click on the column and use the format cells to do the whole column. You can also double click on the format painter and hold down control + shift and the down arrow and it will format the whole column (at least until it hits a break in the data) at one time for you.
    Last edited by Sam Capricci; 08-01-2013 at 10:12 AM.

  7. #7
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    Yes but I am looking to change the default format.

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,377

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    Hmmm, sorry to be wasting your time then. I'm looking into excel options to see if there is a default setting but the only one I'm seeing applying to dates is under advanced and it relates to the 1900 vs 1904 date system.

  9. #9
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    Excel has no way of knowing what the year is of the date is that you are entering.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  10. #10
    Registered User
    Join Date
    04-04-2012
    Location
    Raleigh
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    It seems Excel knows the year is the current year (if you enter 7/29 into a cell, Excel expresses it as 29-Jul, then you manually format the cell to MM/DD/YYYY and Excel expresses the year 2013).

    If Excel knows the year when I manually format the cell, wouldn't it know the year if that same format were the default format?

  11. #11
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,377

    Re: Change default date format from date-month (ex: 29-Jul) to 7/29/2013

    well I noticed it did the same thing in my 2011 iMac excel version at home so I just reformatted it. At work my version is office 2007 (same as yours I think) and if I just type in 7/29 it auto populates it as 7/29/2013 so it must be something coded in under options?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 05-31-2013, 11:20 AM
  2. Replies: 2
    Last Post: 11-04-2012, 04:57 AM
  3. [SOLVED] How change Excel default date format to something useful
    By mjk in forum Excel General
    Replies: 1
    Last Post: 09-26-2005, 04:05 PM
  4. Replies: 2
    Last Post: 07-13-2005, 12:05 PM
  5. Excel Default date for date format
    By smurphy123 in forum Excel General
    Replies: 11
    Last Post: 01-24-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1