I need to display a very big number within Excel, for example a following number: `174587584558159`

.

Excel displays it by using a **scientific notation**, like following: `1.74588E+14`

.

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?

`#`

is doing. Most likely, currently it is formatted as scientific notation. But realized that Excel only stores up to 15 significant digits. So`1234567890123456`

will show`1234567890123450`

with number format. To show the whole number you will need to store it as text. – Scott Craner Jun 28 '18 at 16:54