This question already has an answer here:
I have a form that I'm using to collect responses on in Google Forms. One of the question includes a response that usually starts with a leading zero (like an account number).
When the response is collected in the spreadsheet, the leading zero is removed.
I've changed the format of that particular column to "Plain text", but it doesn't fix the issue for previous responses. Also, when I do this, new responses don't follow the formatting rule - it changes all new responses to "Automatic" formatting.
How can I resolve this?