Editor's Note: This is the first article in a two-part series on decimal representations and decimal arithmetic in general, and on Binary Coded Decimal (BCD) in particular. In this first installment, ...

is numeric data that is stored in binary form. Binary numbers have a base of two and are represented with the digits 0 and 1. are binary decimal numbers that are encoded by using each byte to ...

You can replicate the problem by placing the formula =850*77.1 into an empty cell. Some other combinations of sums that equal 65,535 are also affected by the bug, but others are returning the correct ...