I use sheets as a frontend to display tons of different IDs and credentials associated with my authenticated access to a third-party API.
When calling a specific function, I get the following result:
When you submit to Google Sheets, even if that number is converted to a string, the functions that generated the results before (and I can assure you that this is a plain text string). I get this result in Google Sheets:
It not only interprets plain text as a number, but also rounds the number. Notice that I tried = TO_TEXT in the cell, tried = TEXT in the cell, and tried many different formatting options for numbers, at least not to allow it to be rounded. However, since I've read from other sources, Google Sheets will only use up to 15 characters in numbers until it's round.
I also had the option of simply pasting the data into a cell as plain text from a function exactly the same, but after the contents of those cells have been deleted, the number is no longer generated as it appears as a result of that particular function. In other words, I know that this is possible because I did it with the exact same inputs on the same sheet.
Still, I need one of two results to get the integrity of these IDs:
Leaves do not round off this number
Sheets do not interpret plain text as a number
The second one is much preferable to the first, but I will, if necessary, lead to the first result.
Any hints, what's going on?