Turn Off Scientific Notation

[Guest]

I do math as a hobby sometimes. I like to play with patterns in numbers.

My problem is this: I'm looking for patterns in exponents of 2. I'm trying to get the FULL number with every digit without scientific notation, but at 2^49 (2 to the 49th power) the program starts using scientific notation. How do I turn off scientific notation and get the number in all its glory without an abridged version??? I realize the reason WHY it does this, but I do NOT want this feature to be used in order to find patterns in the numbers. I need the whole thing!!!!

 

[Tom Ogilvy]

Format the cell as Number

Also, excel only shows 15 digits of precision. You are close to that limit.

--
Regards,
Tom Ogilvy

I do math as a hobby sometimes. I like to play with patterns in numbers.

My problem is this: I'm looking for patterns in exponents of 2. I'm

trying to get the FULL number with every digit without scientific notation,
but at 2^49 (2 to the 49th power) the program starts using scientific
notation. How do I turn off scientific notation and get the number in all
its glory without an abridged version??? I realize the reason WHY it does
this, but I do NOT want this feature to be used in order to find patterns in
the numbers. I need the whole thing!!!!

 

[Vasant Nanavati]

I'm not getting this in Excel 2002, but remember that Excel can only handle
15 significant digits. 2^50 is 16 digits and any digits beyond 15 are going
to show up as 0.

--

Vasant

I do math as a hobby sometimes. I like to play with patterns in numbers.

My problem is this: I'm looking for patterns in exponents of 2. I'm

trying to get the FULL number with every digit without scientific notation,
but at 2^49 (2 to the 49th power) the program starts using scientific
notation. How do I turn off scientific notation and get the number in all
its glory without an abridged version??? I realize the reason WHY it does
this, but I do NOT want this feature to be used in order to find patterns in
the numbers. I need the whole thing!!!!

 

[Dana DeLouis]

I do math as a hobby

To explore larger numbers with Excel, you need to use vba. Excel vba is
limited to 2^94. Good luck with "Patterns." :>)

Sub Demo()
Dim n As Variant
Dim j As Long
n = CDec(1)

For j = 1 To 94
n = n * 2
Debug.Print j; FormatNumber(n, 0, , , vbTrue)
Next j
End Sub

Returns:
92 4,951,760,157,141,521,099,596,496,896
93 9,903,520,314,283,042,199,192,993,792
94 19,807,040,628,566,084,398,385,987,584

HTH
Dana DeLouis

I do math as a hobby sometimes. I like to play with patterns in numbers.

My problem is this: I'm looking for patterns in exponents of 2. I'm

trying to get the FULL number with every digit without scientific notation,
but at 2^49 (2 to the 49th power) the program starts using scientific
notation. How do I turn off scientific notation and get the number in all
its glory without an abridged version??? I realize the reason WHY it does
this, but I do NOT want this feature to be used in order to find patterns in
the numbers. I need the whole thing!!!!