https://support.google.com/docs/thread/45190976?hl=en
I tried doing what the above article stated, but it didn't work. Now, to give a clearer picture of what I'm dealing with:
In the first cell, this command is written: =ARRAYFORMULA(3/2^(SEQUENCE(100,1,1,1)))
An under it, there is a bunch of cells occupied with quite small numbers. Eventually, these numbers are so small they are written as a 0. If I press on the cell, the number written with the scientific notation appears. How do I make this go away. Can I increase the spreadsheet's limit of digits in a cell for example?
Best Answer
In Google sheets select the cell the Format → Number then instead of Automatic, select Number and the result will be properly formatted.