Rounding problem in Apple Numbers with multiplying by units in referenced cells

I've designed a self-populating invoice that references timesheets in other tabs (see screenshot below). The hours, calculated to 2 decimal total from each of 4 timesheet tabs, each are referenced to populate a cell in the Hours/Units column in the invoice tab. That gets multiplied by a unit price in the next column in the invoice.

The problem: This then calculates to an amount in the Cost column, which inexplicably rounds to the nearest dollar, but I want it to be accurate to the cent.

I've set the formatting to 2 decimal places but the result always rounds to the nearest dollar.

If I manually input the same Hours/Units amount the result will calculate to 2 decimal points rather than the nearest dollar, even though I haven't changed anything in the Cost column.

Weirdly, the next column, which calculates 13% tax, doesn't do this.

If I create a whole new column to try the same cost calculation it still rounds it even in the brand-new TEST Column.

How can I make this automatically calculate to the nearest cent?