I have the numbers below in a spreadsheet. The top three are entered on the keyboard to two places. Cents. The bottom row is a total of the top three. The problem is i keep getting a '1' in the tenth decimal place when everything past two decimal places should be a zero. Is this a bug in Excel? What am i missing? I've attached the workbook.
12348078.77000000000000000
-12141812.36000000000000000
-167477.00000000000000000
38789.41000000010000000
It's not a bug. Please read this article by MS which also contains suggestions for solving the problem
Wow!! In all my years I've never encountered this. Must just be specific numbers that drive this error. I would never have found it if I wasn't comparing cells using conditional formating to be identical. Could not figure out why I wasn't balancing. I knew I had a problem when I duplicated it on another computer.
Thanks for the info.
Cliff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks