Google Sheets: the 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 for two reasons:
  • 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.
  • Existing conditional formatting rules.


How to fix it

To resolve this issue, follow this step:
  • Remove Google Sheets formatting. This will prevent any data from being automatically formatted.
  • Review existing conditional formatting rules. 

You can learn more about formatting in Google Sheets:

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