Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    I have a user who finds that when she enters numbers from the letter portion of the keyboard into a function, the answer is zero. However, if she uses the numbers from the number pad in the function, the answer is correct.

    Here is her email message: "Additional question for you Meredith. I have found that certain keystrokes are not recognized by the function. For example, I entered all my numbers using the numbered keys above the letters on my keyboard. All results were coming up zero. I went back into my main spreadsheet and, on a hunch, re-entered the numbers using the number keys to the right of my lettered keyboard and that worked. Now I try to use the sum function at the bottom of each column and I get zero again. Is there a way to format my columns so that I am sure that no matter which keys I use for data entry the function equation pulls the right numbers?"

    Please let me know if you have run into this before; I haven't heard of such a problem.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    My only speculation, is that she is entering some other character when she types from the "letter pad" that makes XL thinks she is entering in text and not a number.

    There should be NO difference in the VALUES.

    Could you attach an example workbook that showed this behavior?

    Steve

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

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    What displays in the cell when she enters from the number keys above the letters?
    Legare Coleman

  4. #4
    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: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    Could it be a transition setting?

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

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

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    I've NEVER seen this before. Makes no difference to XL how one enters a number using the Keyboard, as long as they are numbers. Of course when one types a capital o instead of a zero or a capital i as a one, this will happen.

    As a final suspicion, I would check his/her keyboard settings.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    <hr>Makes no difference to XL how one enters a number using the Keyboard, as long as they are numbers<hr>

    Jan,
    This might be "picky" (and NOT related to this post), but your statement is not strictly true. If you are trying to enter "special characters" by using the <alt> keyboard trick, (eg to get degree sign, +/-, some superscripts, etc) you must enter the 4 digit code using the numeric keypad.

    I don't think this is an excel issue, but the trick is used in excel.
    Steve

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

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    Hi Steve,

    <hr>but your statement is not strictly true. If you are trying to enter "special characters" <hr>

    I know, but I <font color=red>said</font color=red> "If you are entering numbers" not "If you are entering special characters".

    How do you call this in English? splitting hairs ? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    I stand corrected (or more accurately: I sit correctly in front of my computer):
    You are Correct:
    "Splitting hairs": is good
    Also:
    "Nit-picking" (nits are the eggs of lice or the young lice themselves)
    Or even:
    "Anal-retentive"
    Or even:
    "A pain-in-the-A$$"

    I have been called them all. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Steve

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

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    I wouldn't for the world call you the last two...
    Thanks for the vocabulary lesson <g>.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)

    Great banter...thanks for the suggestions...but everything seems to have corrected itself; so I'm happy to have it over. Regardless of why. I suspect the user made some embarrassing errors and just wishes to drop the whole thing.

    Again, great banter...and thanks for the various suggestions.

Posting Permissions

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