Working with Zoho IDs in Sheets - Eliminate Scientific Notation
When exporting a data table to Sheets from Analytics, it seems the 18-digit Zoho record ID values get screwed up going back and forth from scientific notation.
Actual ID value from Analytics: 586138000007735001
Comes to Zoho Sheets as: 5.86138000007735E17
Add a decimal place: 586138000007735040.0
So there's clearly some corruption in the process.
How is this avoided?