I have a form that asks the user to enter a number. In my specific situation, it is their Discord ID from Discord, which is normally very long, 17 or 18 characters.
However, once submitted the google sheet does not reflect exactly what is entered. For example, “83707053398294528” enters as “83707053398294530” or “83707053398294500” sometimes. Or it will even turn it scientific with like 8.3707E17 or something similar.
Ive tried changing the format of the column in google sheets, switching from number entry to text entry, etc, but nothing seems to be solving the issue.
Any thoughts or ideas on how to solve this?