Freezing Panes in a Worksheet Pages - Home - Troy City …

8. Excel uses full precision unless values are rounded. Example: The values in column A are the correct original ones, and cell A32 simply adds A30 to A31. Column B has the same numbers, but “formats” them (see Section IV below) to display on the screen with 0 decimal places. The results look odd, however, because they suggest that 3 + 6 = 10. ................
................