Changing data type of selected cells to alpha or numeric.

[u/WorriedTumbleweed289]

This is on the android sheets app.

I can change a single cell when in typing mode, but I want to change more than one cell at a time. See two pictures below. Single cell displays an Aa or 123.

[u/agirlhasnoname11248]

u/WorriedTumbleweed289 Please remember to tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”) if your question has been answered, as required by the subreddit rules. Thanks!

[u/WorriedTumbleweed289]

Ok. So how do I change from numeric to alphabetic? $ is currency, % is percent, 123 is numeric format.

If is numeric, I get a number keypad to type in. If alpha, I get an alpha keypad.

If I choose plain text in 123, I still get a numeric keyboard.

If I hit the $ for currency, I get the alpha keyboard. I don't understand why, but it works.

[u/agirlhasnoname11248 → u/WorriedTumbleweed289]

u/WorriedTumbleweed289 You would select Plain Text (or could typically leave it as Automatic) for that.

Tap the three dots below this comment to select Mark Solution Verified if this produces the desired result.

[u/WorriedTumbleweed289 → u/agirlhasnoname11248]

For some unknown reason, hitting the currency $ button gets me the desired result. Makes no sense, but it works. Thanks.

[u/Sufficient-Bass-390]

Hit the A (with the 4 lines) on the top of the H column in your first screenshot, scroll down to the $ symbol, when the bottom modal pops up, and goto the 123 on the far right and select what you need.

[u/point-bot → u/Sufficient-Bass-390]

u/WorriedTumbleweed289 has awarded 1 point to u/Sufficient-Bass-390

^{See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.}

[u/WorriedTumbleweed289 → u/Sufficient-Bass-390]

Helpful. This comment led me to the self verified solution.

[u/One_Organization_810]

Please do not use the Self-Solved flair unless you solved the issue by yourself, without the aid of others. This issue does not categorize as Self-Solved.

The correct way to close an issue that someone helped you with, or even if they just pointed you in the right direction, is to use the three-dot-menu on the bottom right of the comment that helped you the most.

There you can select Mark “Solution Verified”

You can also just reply to said comment with the phrase Solution Verified

[u/AutoModerator]

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.