Text column converting "%" to decimal

[Dave2]

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!

[Steve]

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

[Dave2 · Accepted solution]

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

[Daisy_Ramirez]

Thanks for this!