Re: Turn Off Scientific Notation

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 08/02/04 

Date: Sun, 1 Aug 2004 23:04:00 -0400

Format the cell as Number

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

-- 
Regards,
Tom Ogilvy
"Jabberwocky" <Jabberwocky@discussions.microsoft.com> wrote in message
news:71A87A02-B0CA-41B5-9251-465962E86367@microsoft.com...
> 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!!!!

Relevant Pages

  • Re: Turn Off Scientific Notation
    ... I'm not getting this in Excel 2002, but remember that Excel can only handle ... "Jabberwocky" wrote in message ... I like to play with patterns in numbers. ... How do I turn off scientific notation and get the number in all ...
    (microsoft.public.excel.programming)
  • Re: determinism, freewill, chaos, and circular causality
    ... Pi is expanded to zillions of digits by a fairly simple ... a million digits to a truly random string of a million digits and then ... There are intelligent patterns which are not distinguishable from ... Even if the brain is currently selecting "random behavior" (which I don't ...
    (comp.ai.philosophy)
  • Re: determinism, freewill, chaos, and circular causality
    ... Pi is expanded to zillions of digits by a fairly simple ... a million digits to a truly random string of a million digits and then ... There are intelligent patterns which are not distinguishable from ... Even if the brain is currently selecting "random behavior" (which I don't ...
    (comp.ai.philosophy)
  • Re: Counting patters
    ... you can do this without a UDF by copying this formula into AG1: ... Filter this column for "duplicate", ... number and combine the digits with powers of 2 to form a number. ... bring these patterns together and eliminate the repeated ones. ...
    (microsoft.public.excel.misc)
  • Re: determinism, freewill, chaos, and circular causality
    ... Pi is expanded to zillions of digits by a fairly simple ... a million digits to a truly random string of a million digits and then ... There are intelligent patterns which are not distinguishable from ... can a computer intelligence surpass a human intelligence and how ...
    (comp.ai.philosophy)