Feb 17 2019
- last edited on
Jun 17 2022
Most of my data entry in Excel is numeric, and I really like to choose the dedicated keyboard for number entry. There are three minor issues:
All pretty minor, but I feel they get between me and one of the most useful pieces of Android software.
Mar 07 2019 11:22 PM
Thank 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.
Mar 11 2019 07:23 AM
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.....
Mar 31 2019 09:58 AM - edited Mar 31 2019 09:59 AM
OK, a bit more information. It's working, to some extent. Here's a sequence...
This is on a Galaxy S8+. Maybe I'm missing something?
May 03 2019 10:50 AM
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.
Mar 04 2020 09:06 AM
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!
Sep 06 2021 04:39 PM
Sep 13 2021 06:45 PM
Sep 15 2021 08:29 AM
I 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.
Sep 16 2021 06:55 AM
Sep 16 2021 07:37 AM
Sep 16 2021 08:47 AM
Sep 21 2021 12:09 PM
Oct 21 2021 08:39 AM
Not 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.)
Oct 21 2021 09:42 AM
Oct 21 2021 01:14 PM
Sorry, I should have added two more steps.
After clicking on the cell and then on Home > Number Format > Text, you may need to click on any other cell, then back onto the original cell. The keyboard should now be alphanumeric, because you have changed the "Number Format" to Text.
Microsoft wisdom dictates that they couldn't possibly change the keyboard immediately to match the "Text" comand. :)
I have just tried this on both my tablet and my android phone. Apart from the difficulty on the phone finding Home> Number Format, it worked on both.
Are you on a tablet or a phone?
Oct 21 2021 01:30 PM