Even if you have the Number format limited to two decimals in Excel, the program remembers a full 15 decimals and will use the fuller number when performing calculations.

How Do I Change Hours & Minutes Into a Decimal Number in Excel?. In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data.

Microsoft Office Excel can be configured to display a number with the default currency symbol. In addition to the options for currency symbols, the format has options for the number of decimal ...