I have a Google Sheet I setup for my clan, and we need to put in very large numbers. We are already using the Scientific Notation for the numbers, but one very large number is not getting treated the same.
We can have numbers as high as even 1.00E1000; currently, it's not processing 7.090E+556 as a number in terms of the chart we have created. I painted the formatting from the other cells into this cell, but it is completely empty on the graph.
What can I do to get a very long line for this user on the graph?
Best Answer
Google Sheets interpret
7.090E+556as text no as a number. This is because Google Sheets can't handle so large numbers.999999999999999(fifteen 9's) are recognized as number but9999999999999999(sixteen 9's) aren't.Reference
What data types does Google Sheets support?