Hi, Joan-
Yours is the second post I've seen today that has addressed the idea of
phantom decimal places. As a workaround, you can use the ROUND
function on a variable in your VBA code or in the worksheet that
supplies the data to your code.

An interesting point: your post says These values in the spreadsheet
are formatted to 2 decimal places
.... but this is the displayed value, not the cell's actual value. It
may be worthwhile for you to apply the ROUND function on the worksheet
and to the code, so the numbers all match up.

Dave O