Text column converting "%" to decimal

AppSheet AppSheet Q&A
1

Hi,

How can I prevent a text column from converting (e.g.) “80%” into “0.8”? I can’t change the column type because some inputs will be strictly written text. Thanks!

2

It’s not AppSheet doing the conversion, it’s your spreadsheet. Change the spreadsheet column’s format to plain text.

3 Likes
3

Well, I feel like an idiot, haha. @Steve thanks!

2 Likes
4

Thanks for this!