Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    seven becomes eight (XL97 sr2 on Win NT4)

    I have one PC where if you enter any number less than 10 that begins with 7 Excel displays an 8 in place of the 7. Thus, key in 7.1 and you get 8.1 but key in 77 and you get 77.

    Point to ponder:
    This behaviour started this morning.
    I can't reproduce it on any other machine.
    It doesn't matter if you use the 7 on the number key pad or the 7 above the letters on the main keyboard.
    Both 7 keys behave correctly in other applications.
    It occurs on any spreadsheet in any cell.
    The cells are all formatted to General and all other numbers behave correctly.
    Autofilling the sequence 1,2,...5,6 correctly continues 7, 8 but as soon as you edit the cell with 7 in it it becomes 8.
    There are no macros visible in the VBE and the 'macro protection feature' does not warn of any.
    I have rebooted to no avail.
    I have deleted the username.xlb file in the winnt folder to no avail.

    I am going to reinstall XL unless someone else can think of something I missed.

    stuck
    *****EDITED BY STUCK*****
    Problem solved, an autocorrect entry to replace 7 with 8 had mysteriously appeared.
    Intellisense strikes again!

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

    Re: seven becomes eight (XL97 sr2 on Win NT4)

    Autocorrect is fooling you. Tools, autocorrect, find the 7 in the list below and press delete.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: seven becomes eight (XL97 sr2 on Win NT4)

    Thank you Jan but I had just got there!

    The truth is coming out now... the user in question has remembered that yesterday they were trying to do a replace 7 with 8 and for some reason resorted to Autocorrect to achieve their aim. However, they didn't think to mention this until the offending entry had been unearthed because they were working in Word when they were messing around in this way.

    (un)stuck

Posting Permissions

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