Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Date format changing to present year.

Home Forums Office Office XP / 2003 General Issues Date format changing to present year.

Viewing 1 post (of 1 total)
  • Author
    Posts

  • Blood
    Member
    #152877

    Hello

    I am using Excel 2003 on an XP Pro SP3 machine whose region is set to English UK.

    I have a spreadsheet that I have been using for years and which I have had no problems with until today.

    One of the columns is formatted with a custom date format:

    Format Cells>Custom>mmm-yy

    When I type a date e.g. aug10 it will convert it to Aug-10. That’s fine and is how I expect it to work.

    Today, when I type aug10 or aug-10, after pressing the date is displayed as Aug-11. Anything I now type that has a year on or after 01 (2001) is displayed as 11 (2011).

    However, anything typed in as mmm00 or earlier displays as expected.

    If I re-type mmmdd dates in existing cells they, too, are converted to mmm-11 (except for 00 or earlier).

    If I type aug2010 then the date is displayed correctly: Aug-10

    Anyone know why this is happening, please? I know that I have a solution in that typing the year as four digits instead of two works, but I would like to understand why this behaviour has changed. Is it related to the recent date corrections provided by Windows Update?

    Thanks!

    [Edit]
    False Alarm! The short date format under Regional Settings in Control Panel had changed so that the year was displayed first (US style). Changing this to dd/mm/yy fixed it!

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: