+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Date entry is wrong

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    69

    Date entry is wrong

    I have my date columns formatted to display as Jan 24 8:30, with older versions of excel I entered the data as 1/24 8:30 but with 2007 I have to enter it as 24/1 8:30 and that is causing confusion and errors with some users. Is there a way to change the way the date/time is entered?

  2. #2
    Forum Contributor
    Join Date
    04-21-2007
    Location
    Lima, Peru
    MS-Off Ver
    2000, 2007, 2010
    Posts
    674

    Re: Date entry is wrong

    Hi

    With 2007 if you right click and then go to format cells you can see if you click on the date section the type of format that you have. Check to see that the locale is set correctly as this will affect how your entry is displayed.

    Regards

    Jeff

  3. #3
    Registered User
    Join Date
    02-08-2007
    Posts
    69

    Re: Date entry is wrong

    Thanks Jeff but the displayed format is correct, what I would like to change is the way I type it in. Currently I have to type in 24/01 8:30 and it shows up in the cell as Jan 24 8:30, I would like to be able to type in 1/24 8:30 to get the same result.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Date entry is wrong

    Check your regional settings in Control Panel?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    02-08-2007
    Posts
    69

    Re: Date entry is wrong

    Thanks shg that did the trick. I'll have to remember that, lots of setting in there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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