If you haven’t already heard about the Excel bug, open up Excel 2007 and try multiplying 77.1 with 850:<\/p>\n
=77.1*850<\/p>\n
Clearly that should give you 65,535. But Excel 2007 returns 100,000. Oops.<\/p>\n
It turns out it’s just a presentational bug. The displayed result is wrong, but the underlying value is correct. If you were to create a graph or access the value from VBA, you’d get the right result. Read Joel’s post<\/a> for a clear explanation of why this is.<\/p>\n Speaking of Office 2007, I had a near disaster with Outlook today when it refused to work. It crashed on startup, and kept trying to restart itself, only to crash again. Got it sorted in the end. But I’ve been meaning to implement a decent backup solution for Outlook since I switched to it a few months ago. So today I installed BackupOutlook<\/a> from our friends at Wisco<\/a>. Does the job nicely. If you’re looking for a decent Outlook Backup tool you should check it out.<\/p>\n","protected":false},"excerpt":{"rendered":" If you haven’t already heard about the Excel bug, open up Excel 2007 and try multiplying 77.1 with 850: =77.1*850 Clearly that should give you 65,535. But Excel 2007 returns 100,000. Oops. It turns out it’s just a presentational bug. The displayed result is wrong, but the underlying value is correct. If you were to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts\/205"}],"collection":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":0,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mjtnet.com\/blog\/wp-json\/wp\/v2\/tags?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}