Google-sheets – Google Sheets not processing very large numbers

google sheets

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+556 as text no as a number. This is because Google Sheets can't handle so large numbers.

999999999999999 (fifteen 9's) are recognized as number but
9999999999999999 (sixteen 9's) aren't.

Reference

What data types does Google Sheets support?