Forum Discussion
Excel on Android - numeric keypad
MicrosoftThank you for the feedback!
Can you check this on the latest Beta build?
We have included auto-surfacing the number keyboard based on cell formatting.
We will look into the other feedbacks.
Good day,
I'm using Excel 1.0.1 (16.0.11601.20074) on Lenovo TB3-730x very often every day.
My question is: is it possible to permanently disable the switching between the various keyboard based on cell formatting, since for me this auto-surfacing is counterproductive: the Hacker's Keyboard, the default keyboard I'm using, already has all the necessary letters and numbers I need.
Thanks for your reply.
- Very frustrating! Now I'm trying to type in a string and it keeps bringing me the numbers keyboard. I can't change the keyboard back to alphanumeric.
Microsoft should include a user setting to enable or disable this featureNot brilliant, but probably the best solution available: -
Click on the cell.
Click on the Home > Number Format icon (Fifth icon along the Home ribbon on my tablet)
At the bottom of this drop-down menu, click on "Text".
The cell will now be formatted as text, and the keyboard will be the alphanumeric one.
(To get the numeric keyboard back, click on a cell, then Number Format > whatever takes your fancy.)
I'm not seeing the number keyboard auto-surface - I'm on 1.0.1 (16.0.11425.20016). For example, this is on cells formatted as "Number", zero decimal places. Thanks.....
OK, a bit more information. It's working, to some extent. Here's a sequence...
- Open a XLSX
- Click on a cell known to be formatted as a number
- Click the function bar to enter a value. At this time, the on-board keyboard appears. I'm using gboard, and it's just the regular QWERTY layout
- Before entering a value, click on another numeric format cell. Now the numeric keyboard does appear.
This is on a Galaxy S8+. Maybe I'm missing something?
- Siddharth_Vora
Appreciate the feedback.
Will look into it and get back.
I'd like to follow up on this and ask how I can format a cell so that the numeric keyboard pops up when I go to enter a value. (I'm assuming that what "auto-surfacing the number keyboard based on cell formatting" means.) Thanks!
- Siddharth_Vora
blueskies you can format the cell as numeric, currency, date, time, datetime.
In that case double tapping the cell to edit should bring up the numeric keyboard.
That would make sense! Unfortunately it doesn't happen consistently that cells formatted for number default to the number keyboard. Maybe it's an android bug.
Thanks!
- I hate that yall took the keyboard / number pad selection off. I have spreadsheets that in the "auto-surfacing" update that I need the keyboard but only have use of the number pad and vice-versa. Please change it back. This is NOT a good update.
- Hi! I read you comment, is that true?.
I'm just looking for an answer, why in one of my tablet, excel gives me an option to switch between ABC keyboard to numeric panel, and in other not ?
If someone knows please I need help with this..
ThanksI had the same problem today.The numeric keypad switched off and I couldn't get the little keybd icon back at the top of the qwerty surface kybd. It seemed to switch off randomly.I tried opening a new spreadsheet and double clicked in a cell and it came back! All my other spreadsheets were now ok,ie I was able to switch between numeric and qwerty ok.I don't know if this is a fix or not but time will tell.
