AppleWorks Spreadsheet: Displayed Numbers Are Sometimes Rounded

The AppleWorks spreadsheet displays numbers as close to the calculated value as it can, given the display format chosen by the user.
If the user specifies that only two places are displayed, AppleWorks still calculates it up to nine digits, and can display up to nine digits (seven digits past the decimal point).

For example, the calculation .07 * 2.5 results in .175, but if the display is set to just two decimal places, the number displayed is .18. Any subsequent calculations will be based on the actual value .175, not on the displayed value of .18. AppleWorks calculates to all significant digits and displays according to display values set by the user.
Published Date: Feb 18, 2012