Forum Discussion

MarkvanGeffen's avatar
MarkvanGeffen
Copper Contributor
Aug 04, 2021

Type a , with numpad on keyboard instead of a . (Excel Online/ , / . / numpad)

Hi community,   I have a keyboard with a numpad. My language settings are (Nederlands) in Excel Online. When I type a . (next to 0 on numpad) I would like the default behavior to be a , like local ...
Excel for web
bnaranjo's avatar
bnaranjo
Copper Contributor
Apr 06, 2022

MarkvanGeffen Sebastien_B  Do you happen to find something. i can´t believe this still an issue...

 

is not related to regional settings (because the comma is well detected as decimal separator from the qwerty keyboad), the thing is like it doesn´t detect well the key in the numpad, and it literally types the "." instead of the key in your regional settings ","

 

Thanks

MarkvanGeffen's avatar
MarkvanGeffen
Copper Contributor
Apr 06, 2022

unfortunately the issue is not resolved… I don’t have the answer. This is not a big but a design error.

 

bnaranjo 

  • MarkvanGeffen's avatar
    MarkvanGeffen
    Copper Contributor
    Apr 07, 2022
    Thanks, I will try this response.
  • bnaranjo's avatar
    bnaranjo
    Copper Contributor
    Apr 06, 2022

    Hi Sebastien_B and MarkvanGeffen, i found a dirty workaround.

     

    i went here: https://superuser.com/questions/1007032/change-numpad-to-windows-10, and here: https://superuser.com/questions/1173975/rebinding-numpad-location-104-to-regular-dot-location-54 and end up downloading this: https://www.bleepingcomputer.com/download/keytweak/

     

    that let me to create a "keychange.reg" that lets me change "physically" the numpad key to a comma, copy the text into ".reg" file and just import it and it will work, or if you prefer, download the tool and prepare your own:

     

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]
    "Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,33,00,53,00,00,00,00,00

     

     

     

    Now the problem is "solved", but on the downside, that numpad "." button now is going to be forever a comma, and it will not change back, no matter what changes are made in regional settings. BTW: i use a PC and USB keyboard. i do not know if the .reg will work for bluetooth, etc.., so USE AS-IS.

  • Sebastien_B's avatar
    Sebastien_B
    Copper Contributor
    Apr 06, 2022

    MarkvanGeffen it could be a big problem depending your language area ...

Resources