I have a spreadsheet that displays ledgers over a period of time. As values carry forward each month, the debit & credit columns either reduce or increase the balance value. This seems pretty straightforward.
After applying "Accounting" formatting to the cell it displayed "0.00" rather than the "-" you'd typically see with this format. So I increased the decimal places to debug and was surprised to see that the balance had decimal points yet the debit / credit and balance carried forward values were rounded to two decimal places.
The "seed" values were all rounded to two decimal places so, I guess the question is, does the rounding not apply to future calculations on the rounded value? Additionally, is there any rational explanation for why the value of
0.000000000000909494701772928000 and not
0.00? I expect this with code when using
decimal types but am not sure if this is the case here or not.