Google Sheets: format of data changes when added to my spreadsheet

Symptoms

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.
 

Causes

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.

You can learn more about formatting in Google Sheets.

 
 
 
Was this article helpful?
1 out of 12 found this helpful