Microsoft Excel bug?
<br /="/"/><div>Anybody knows how to use MS Excell to calculate/represent an integer number > 16 digits. For example, I was trying to calculate 3^32. This is a number > 16 digits and with last digit being 1. However, my Excel gives me 1,853,020,188,851,840. And if you continue to go 3^33 ... and larger index, the last digits are all wrong. I always has the impression that Excel is "double precesion" that mean it can handle 32 digits of a number. Maybe this is a bug? Thanks.</div><div> </div><div> </div><span style="display:none;">www.ddhw.com</span><br /="/"/><br /="/"/> <div style="MARGIN-TOP:20px;MARGIN-LEFT:0;MARGIN-BOTTOM:0;float:left"></div>Microsoft Excel 处理的数字为双精度数，其有效数字仅有32位（2进制）即2^32-1
<br /="/"/> Microsoft Excel 处理的数字为双精度数，其有效数字仅有32位（2进制）即2^32-1<br /="/"/><br /="/"/><br /="/"/><br /="/"/><br /="/"/><div style="MARGIN-TOP:20px;MARGIN-LEFT:5px;MARGIN-BOTTOM:10px"><br /="/"/><img /="/" src="/img/sign.gif"></img><a href="http://www.ddhw.org" target="_top"><span style="FONT-SIZE:12px;COLOR:#999999;font-weight:bold">www.ddhw.org</span></a>---<div style="width:450px;MARGIN-LEFT:10px"><br /="/"/><input /="/" src="http://upload.ddhw.cn/image/2010/10/18/76707.jpg" style="CURSOR: default" type="image"/><br /="/"/></div></div>回复：Microsoft Excel 处理的数字为双精度数，其有效数字仅有32位（2进制）即2^32
<table cellpadding="8" height="100%" width="100%"><tr><td valign="top"><br /="/"/><div>是10进位的32位数字， 还是2进位的？ 你没有讲明白. 谢谢.<span style="display:none;">www.ddhw.com</span></div><div> </div><span style="display:none;">www.ddhw.com</span><br /="/"/><br /="/"/> <div style="MARGIN-TOP:20px;MARGIN-LEFT:0;MARGIN-BOTTOM:0;float:left"></div></td></tr></table>
页:
[1]