Hi CD,

I can definitely help you with that. When Excel performs calculations, it usually uses the values stored in cells referenced by the formula. However, you can change the precision of calculations so that Excel uses the displayed value instead of the stored value when it recalculates formulas.

Here's how you can change the precision of calculations in Excel:

1. Select the cell or range of cells that you want to change the precision for.
2. Right-click on the selection and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, select the "Number" tab.
4. In the Category list, select "Number" or "Currency" (depending on the format you want to use).
5. In the Decimal places box, enter the number of decimal places you want to display.
6. Click "OK" to close the dialog box.

Now, when you perform calculations on the selected cells, Excel will use the displayed value instead of the stored value. This should solve the problem you were having.