View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Turn Off Scientific Notation

Format the cell as Number

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

--
Regards,
Tom Ogilvy


"Jabberwocky" wrote in message
...
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!!!!