Forum Discussion
Excel on Android - numeric keypad
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.
Microsoft should include a user setting to enable or disable this feature
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.)
- Hi, I've followed your instructions but it didn't work at all. If a cell has the numeric keyboard, changing the cell info to "text" just alters the details in the cell. It makes no difference to the keyboard at all.
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?
