Results 1 to 5 of 5
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Excel 97 - Import of dates from text files (97)

    2000 and 2002 have the facility to change the base year using regional settings so that dates entered as 2 digit years, say 12/02/11 will be treated as 1900 rather than 2000. This facility is NOT functional in 97.
    Is there an easy way to do this so that when importing dates with 2 digits, they get parsed to the correct year. We need a cut off of year 4. Assume it is NOT possible to get the dates in the text file as 2 digits.
    I can write a utility in VB or VBA to do this and replace the Excel Import Wizard (Silly name anyway because it should be called Warlock), but before I do so is there a simple fix or registry hack that anyone knows about?
    Andrew

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Import of dates from text files (97)

    Not with XL 97.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Honolulu, HI
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97 - Import of dates from text files (97)

    If you knew that your imported dates were all after 1929, you could rely on Excel's arbitrary choice of century. Any two-digit year from 30 to 99, Excel assumes 1900. For years 00 to 29, Excel picks 2000.

    John Jacobson

  4. #4
    akkw
    Guest

    Re: Excel 97 - Import of dates from text files (97)

    Yes I thought as much, I was just hoping for a simple work around.
    Guess I'll write the Parse Routine myself in VBA and make it into an ADD-IN

  5. #5
    akkw
    Guest

    Re: Excel 97 - Import of dates from text files (97)

    Unfortunately they are NOT. That was why I needed to change the base date, as you can in Excel 2000 and above.
    Never mind, I'll write the VBA data paring routine in vBA and create it as an ADD-IN so that it can be installed onto PC's with only 97 on.

Posting Permissions

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