TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Last digits are changed to zeroes when you type long numbers in cells of Excel

2 pointsby jsvinealmost 9 years ago

1 comment

Someonealmost 9 years ago
<i>&quot;Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers&quot;</i><p><a href="https:&#x2F;&#x2F;people.eecs.berkeley.edu&#x2F;~wkahan&#x2F;Mindless.pdf" rel="nofollow">https:&#x2F;&#x2F;people.eecs.berkeley.edu&#x2F;~wkahan&#x2F;Mindless.pdf</a> disagrees with that (the author knows a bit about IEEE 754, having been &quot;the primary architect behind the standard&quot; (<a href="https:&#x2F;&#x2F;en.m.wikipedia.org&#x2F;wiki&#x2F;William_Kahan)" rel="nofollow">https:&#x2F;&#x2F;en.m.wikipedia.org&#x2F;wiki&#x2F;William_Kahan)</a>)