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
- Nov 03 Mon 2008 20:47
??? get quot;#NUMquot; doing 190^190
close
全站熱搜
留言列表
發表留言
留言列表

