Data added in the google sheet has ' added in front of it by default

Hi All,

I created a form from google sheets. When I am adding data and saving it, the data is added as '1234567890722. Note the special character in front of the number. Although I do not add any special character in the form.

The field is text both in the form and the back end google sheet. Please refer to the screenshots below for the better explaination.

Any suggestions what might be happening? Because of this I am not able to add data validations.

0 4 148
4 REPLIES 4
Top Labels in this Space