I need to display a very big number within Excel, for example a following number:
Excel displays it by using a scientific notation, like following:
I tried to format a cell like a text, but it didn't help. There's an option to add a single quotation mark at the beginning, but I don't want to use this approach.
What I have found that when I use a custom format with cell by using a pound sign -
# it shows a number as I need, but I can't find description of this behavior on the Internet, so I hesitate to use it. The only description I've found, is that it can define how many digits it shows within the fraction part.
So, my question is: can I use
# sign to show very big numbers within Excel, and if yes, why? Right now I'm using Excel 2016 (Windows), is this behavior will be same on older versions of Excel?