Hello, I have an app that I have only one f...

(Aris Toupis) #1

Hello,

I have an app that I have only one form. I have a column that when I insert number like 4digit ( 1234) in google spreedsheet it converts by itself in '1234 . Automatically inserts this character

How I can fix this?

My column is text because I have to insert either 4 digit number or text like f123

(Aleksi Alkio) #2

When the column type is a text and you enter a number, it will add that '. The purpose of this is the same than any spreadsheet. It will add that so if you add a number like 0123, it will keep that leading zero as well. If you want to calculate with that value as a number, you can convert that as a number with a formula NUMBER([ColumnName]).

(Aris Toupis) #3

where to put this formula?

(Aleksi Alkio) #4

Difficult to say. I mentioned it in generally. It depends where you want to calculate with it.

(Aris Toupis) #5

The problem is that the column is text, I tried to put this formula and it didn’t work.

(Aleksi Alkio) #6

You can use that, but not in that same column because it’s a text column.