Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Force 4 digit year (sr1)

    Is there a way to force Excel to use only 4 digit years?
    I am reading in text files that have four digit years but Excel converts them to 2 digits.

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

    Re: Force 4 digit year (sr1)

    Excel dates are actually stored as the number of days since December 31, 1899. If you enter a four digit year, then Excel will convert it to that value. If you enter a two digit year, then Excel will assume the other two digits (what it assumes depends on which version you have), and then convert it to the number of days since 12/31/1899. Excel does not keep the year as either two or four digits.

    What you are probably having a problem with is that the default date display format only displays two digits for the year. If you have a cell that contains a date, then you can select that cell, and then select Cells from the Format menu. In the Dialog box, select Date in the category list, and then select the date format you like from the list. There should be at least one with four digit year. If you don't see a format that you like, then select Custom in the category list and create a format that displays it the way you want (if you don't know how, tell us what format you want and we can give you the format to get it).
    Legare Coleman

Posting Permissions

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