Sometimes, when specifying charges on a wand with a formula, as listed in the docs, the column formats it as a date. It happens often, but not always.
For example, on of the last items I had is a wand with 10 charges, so the Quantity is the formula "=10/50". However, the display in the "Qty" column shows Jan-00.
I'm using Excel 2010 but have seen it on Excel 2007 as well.
[v1.70] formatting issue with charges
Re: [v1.70] formatting issue with charges
I was unable to replicate the problem, but I made sure all the Qty column is set to 'general'...
(I hesitated forcing it to Number, as I find it annoying that it adds decimal places when not needed, or does not show them when needed...)
I'll tag this as pending for further tests in the next update. Thanks!
admin
(I hesitated forcing it to Number, as I find it annoying that it adds decimal places when not needed, or does not show them when needed...)
I'll tag this as pending for further tests in the next update. Thanks!
admin