Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    San Francisco, California
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weird date formatting error (2000 SP-3)

    This morning Excel started doing strange things to dates typed into cells (not pasted, not imported). For instance, if I enter 6/26 it changes my entry to 01/06/2026, and displays it as 6/1/26 -- it's reversing the month and day and changing the year. But it's not consistent. If I enter 6/1 it properly formats the entry as 06/01/2008, but still flips the month and day so it's displayed as 1/6/08. The formatting of the cell looks fine -- it's set as MM/DD/YY (the 2nd option in the list). I checked older entries in an existing spreadsheet and they show the same format and are display properly. But if I change them -- even entering the date that's currently in the cell, it messes up the date and the format. This happens on a new spreadsheet and on existing ones (although on a new spreadsheet it shows the entry as 01/06/2026 but displays it as Jun-26). If I type 6/26/08 in a cell it doesn't change the entry or format, but it left-justfies the entry, whereas dates are normally right-justified.

    I don't see anyplace to tell Excel to use a US date format instead of Euro date format. And I have no idea why it seems to think the year is 2026.

    I may have picked up a virus yesterday, although Avast said it caught and deleted it. I've run Microsoft's OneCare virus scan and Spybot S&D and neither found a problem.

    Any ideas?

    -- Robert

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weird date formatting error (2000 SP-3)

    Has your system date format in the Date, Time, Language and Regional Settings control panel changed?

  3. #3
    Star Lounger
    Join Date
    May 2003
    Location
    San Francisco, California
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weird date formatting error (2000 SP-3)

    Yes! That was it. On the Regional and Languages control panel's Regional Options/Date tab I changed the Short Date format to MM/dd/yyyy (from dd/MM/yyyy) and the problem went away. Thank you!

    Robert

Posting Permissions

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