Google Sheets: format of data changes when added to my spreadsheet
You've entered data into your spreadsheet by Zap, and the format of the data has changed unexpectedly. For instance, numbers might be turning into dates, dates might turn into numbers, or text might turn into numbers.
This happens because Google Sheets is automatically formatting the data you enter based on the type of data it thinks it is. For example, if you enter a number that looks like a date, Google Sheets will automatically format it as a date.
How to fix it
To resolve this issue, follow this step:
Remove Google Sheets formatting. To prevent Google Sheets from automatically formatting your data, you can format the column as text in Google Sheets. This will prevent any data from being automatically formatted.