Calculated Values
A particular spreadsheet of mine automatically turns numerical math formulas
into the calculated value. (e.g. =A13/8/100 becomes =A13/.008 which, by the
way, isn't even correct for precedence of operations). If I type
=A13/(8)/(100) the formula is preserved, and the calculation is correct. I
don't have this problem on other spreadsheets; how do I fix this?
|