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

Aris_Toupis · 10-30-2018 05:00 PM

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

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

where to put this formula?

Aleksi_Alkio

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

Aris_Toupis

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

Aleksi_Alkio

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