close

I cannot get 190^190 calculation in the excel.

The result is an #num. Would appreciate some advice
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Excel cannot handle such a large number, type specifications into help and
calculation specifications and you'll see

largest number you can type is 9.99999999999999E307, largest positive number
allowed is
1.79769313486231E308--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Jaylinquot; gt; wrote in message
...
gt;I cannot get 190^190 calculation in the excel.
gt;
gt; The result is an #num. Would appreciate some advice
gt; --
gt; Thanks a million for your time and expert advice :-)
gt; Jaylin
gt; *****Jaylin Message ended*******Thank you ver much for your advice.

I wonder if you would know how to fix it
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******quot;Peo Sjoblomquot; wrote:

gt; Excel cannot handle such a large number, type specifications into help and
gt; calculation specifications and you'll see
gt;
gt; largest number you can type is 9.99999999999999E307, largest positive number
gt; allowed is
gt; 1.79769313486231E308
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Jaylinquot; gt; wrote in message
gt; ...
gt; gt;I cannot get 190^190 calculation in the excel.
gt; gt;
gt; gt; The result is an #num. Would appreciate some advice
gt; gt; --
gt; gt; Thanks a million for your time and expert advice :-)
gt; gt; Jaylin
gt; gt; *****Jaylin Message ended*******
gt;
gt;

I'm not Peo, but I read his response is not to use excel if you want that
number.

Windows calculator returns this:
9.1872213705547406791477137556835e 432

Jaylin wrote:
gt;
gt; Thank you ver much for your advice.
gt;
gt; I wonder if you would know how to fix it
gt; --
gt; Thanks a million for your time and expert advice :-)
gt; Jaylin
gt; *****Jaylin Message ended*******
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Excel cannot handle such a large number, type specifications into help and
gt; gt; calculation specifications and you'll see
gt; gt;
gt; gt; largest number you can type is 9.99999999999999E307, largest positive number
gt; gt; allowed is
gt; gt; 1.79769313486231E308
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Northwest Excel Solutions
gt; gt;
gt; gt; www.nwexcelsolutions.com
gt; gt;
gt; gt; (remove ^^ from email address)
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Jaylinquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I cannot get 190^190 calculation in the excel.
gt; gt; gt;
gt; gt; gt; The result is an #num. Would appreciate some advice
gt; gt; gt; --
gt; gt; gt; Thanks a million for your time and expert advice :-)
gt; gt; gt; Jaylin
gt; gt; gt; *****Jaylin Message ended*******
gt; gt;
gt; gt;

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()