How do you convert a text field to a number so you can do calculations on it? I’ve had to use ANY and SELECT to match on multiple columns to retrieve a value byt unfortunately this comes out as a text value not a number. The value amityville in is a number. Alternatively does anybody know how to …

number([column name]) number("100")

Thanks. Couldn’t see it at first!

How do I do it when the number is less than 12? It gets confused with a moth

Please post a screenshot of the entire expression that doesn’t work as desired.

Please can I resurrect this question. I am hoping to turn text into an numeric amoubt but I’m really struggling to get any answers. Eg. Apple = 10, orange =20. So the user selects apple. They get the answer = 10. Many thanks @Steve

Convert text to number?

AppSheet AppSheet Q&A

Steve August 14, 2020, 1:27pm 4

For reference:

Topic		Replies	Views
Extract number from a text string and convert into number AppSheet Q&A expressions	8	118	February 14, 2025
text to number AppSheet Q&A other	3	116	March 13, 2024
Convert to number AppSheet Q&A expressions	2	22	December 23, 2022

Convert text to number?

AI Suggested topics