Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Error After SP3 (Excel 2000 SP3)

    After installing SP3 I am having problems with the date in a spreadsheet created before SP3. The file has over 2300 rows and one cell in each row is formated as mm/dd/yyyy. The date worked fine before SP3, but it could be coincidence that it isn't working now. Before, I would enter 10-01 and the formatted cell would display 10/01/2003. Today I entered 10-01 and the result is 1/10/1900. The date works fine in a blank spreadsheet and even on other tabs in the same spreadsheet. Any ideas or suggestions?

    TIA
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Error After SP3 (Excel 2000 SP3)

    Check out the settings in Tools, options, transition. Uncheck the boxes below the line "Sheet Options"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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