Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » evil floating point numbers   (RSS)

Excel 2007 Display bug fixed

Unless you have been on a deserted tropical island, you would have heard about the Excel 2007 bug whereby =850*77.1 would display 100000 instead of 65535. The issue occured when displaying numbers in the ranges of 65534.99999999995 to 65535 and 65535.99999999995
 
Page view tracker