Values get more decimal than they should have
Created originally on Bitbucket by Anonymous
Hi,
I wrote a python program with some calculation (every number has only 2 decimals). The range E2:N368 consists of 2 decimal numbers. The program saves to data (no formulas, only the calculated numbers) to the worksheet.
x = -5697.33 wscell = ws.cell('E362') wscell.value = x wscell.style.number_format.format_code = '0.00'
Printing the cell value returns -5697.33 print ws.cell('E362').value -5697.33
Whereas when it is saved to disk, one finds: -5697.330000000076
Any ideas?