0

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?

  • There are 10^80 atoms in the whole universe, so I am curious on why do you need to store such a large numbers. There is probably a limit on the data you can store in a cell (for text it is 50k characters). Nevertheless, you can store the number and the exponent on different cells so your number for example would be 1.00 in one cell and 1000 on another, well within the limits. – Oren Pinsky Dec 12 '18 at 9:52
  • @OrenPinsky See picture added with my last edit – Canadian Luke Dec 12 '18 at 18:23
  • I still don't get why you need these numbers. A simple way to make your graph is to make it a log graph, so instead of plotting and recording the 1e1000, you just plot the 1000 and ignore the 1. The precision you would loose would be minimal. – Oren Pinsky Dec 12 '18 at 20:51
  • I think I will. Thanks @OrenPinsky – Canadian Luke Dec 12 '18 at 22:03
0

Google Sheets interpret 7.090E+556 as text no as a number. This is because Google Sheets can't handle so large numbers.

Reference

What data types does Google Sheets support?

  • Perfect, that explains it. Thanks – Canadian Luke Dec 12 '18 at 22:03

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.