Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Weird behavior in Excel (2000 SR-1)

    Picture this: I've selected cell H5, where I want to insert the time of day in military format--in this case, 0700 for 7:00 a.m. The cell is formatted for time. I press zero, then seven...and immediately the selection jumps to cell address A5! Nothing appears in the cell where I wanted it to go. Similar things happen in other cells. What's going on here? And how can I fix the problem? I'd used this same file just a couple of days before this behavior began.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Weird behavior in Excel (2000 SR-1)

    Hi,
    It sounds to me as though you've got NumLock turned off, which makes 7 the Home key.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Weird behavior in Excel (2000 SR-1)

    Well, I'll be sheep-dipped! Thank you!

    I've noticed that some keys on the numeric keypad will do other stuff if you turn off NumLock. The keyboard already has navigation keys (arrow keys), PageUp/PageDown keys, Home and End keys.... Why would anybody want or need those redundant keys on the numeric keypad? I'm sure there must be a good reason--can anybody tell me what it is?

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Weird behavior in Excel (2000 SR-1)

    Because the original IBM PC keyboard (maybe through the AT series, I don't remember) didn't have cursor movement keys separate from the numeric keys, users had to switch between numbers and cursor movement using NumLock, and backward compatibility has been retained.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Weird behavior in Excel (2000 SR-1)

    In the BIOS for your system you can specify if the numlock will be on automatically or not.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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